mysql locate()函数
2024-08-30 19:13:31
mysql> select * from test;
+----+------------+-------+-----------+
| id | name | score | subject |
+----+------------+-------+-----------+
| | xiaoming | | shuxue |
| | xiaohong | | shuxue |
| | xiaohong | | english |
| | xiaohong | | physics |
| | xiaohong | | astronaut |
| | xiaoming | | physics |
| | xiaoming | | astronaut |
| | xiaoming | | english |
| | xiaobai | | astronaut |
| | .2xiaobai | | english |
| | .2xiaobai | | physics |
| | 3xiaobai | | shuxue |
| | 123xiaohei | | astronaut |
| | xiaohei | | shuxue |
| | xiaohei | | physics |
| | .12xiaohei | | english |
+----+------------+-------+-----------+
rows in set (0.00 sec) mysql> select locate("xiao",name) from test where id=;
+---------------------+
| locate("xiao",name) |
+---------------------+
| |
+---------------------+
row in set (0.00 sec) mysql> select locate("iao",name) from test where id=;
+--------------------+
| locate("iao",name) |
+--------------------+
| |
+--------------------+
row in set (0.00 sec) mysql> select locate("o",name) from test where id=;
+------------------+
| locate("o",name) |
+------------------+
| |
+------------------+
row in set (0.00 sec) mysql> select locate("o",name,) from test where id=;
+--------------------+
| locate("o",name,) |
+--------------------+
| |
+--------------------+
row in set (0.00 sec)
最新文章
- 【微信要跪】 iOS 应用如何完全支持 IPv6-ONLY 网络?
- mvc项目controller重命名了,用原网页url访问不了了,怎么办?
- python del 注意点
- WCF初探-10:WCF客户端调用服务
- 【网络编程】——connect函数遇见EINTR的处理
- Effective C++ 1.让自己习惯C++
- SMTP Failed on Process Scheduler
- Cpp多重继承会产生的问题
- Spark 1.60的executor schedule
- Memcache的基本应用
- CorePlot学习零---安装
- Java程序员须知的七个日志管理工具(转)
- 2014华为机试西安地区B组试题
- Haskell 笔记(三)类型系统
- 9.mybatis动态SQL标签的用法
- Find modern, interactive web-based charts for R at the htmlwidgets gallery
- 【javascript】详解javascript闭包 — 大家准备好瓜子,我要开始讲故事啦~~
- spring事务详解
- 【Android学习笔记】Android Studio简单断点调试
- RSP小组——团队冲刺博客五