MySQL基础之 LIKE操作符
2023-09-11 14:18:55 时间
LIKE操作符
作用:用于在WHERE子句中搜索列中的指定模式。
语法:SELECT COLUMN_NAME FROM TABLE_NAME WHERE COLUMN_NAME LIKE PATTERN;
现在我们创建一个表
mysql> SELECT * FROM information; +------+----------+-----------------+-----------+ | id | name | address | city | +------+----------+-----------------+-----------+ | 1001 | xiaoming | NiuJin | England | | 1002 | xiaochen | Oxford street | New York | | 1003 | xiaoming | chaoyang street | Beijing | | 1004 | xiaohua | haha street | Zhengzhou | +------+----------+-----------------+-----------+ 4 rows in set (0.00 sec)
1、找出以“E”开头的城市的个人信息
mysql> SELECT * FROM information WHERE city LIKE 'E%'; +------+----------+---------+---------+ | id | name | address | city | +------+----------+---------+---------+ | 1001 | xiaoming | NiuJin | England | +------+----------+---------+---------+ 1 row in set (0.00 sec)
2、找出包含“ch”子串的姓名的个人信息
mysql> SELECT * FROM information WHERE name LIKE '%ch%'; +------+----------+---------------+----------+ | id | name | address | city | +------+----------+---------------+----------+ | 1002 | xiaochen | Oxford street | New York | +------+----------+---------------+----------+ 1 row in set (0.00 sec)
3、找出不包含“ch”子串的姓名的个人信息
mysql> SELECT * FROM information WHERE name NOT LIKE '%ch%'; +------+----------+-----------------+-----------+ | id | name | address | city | +------+----------+-----------------+-----------+ | 1001 | xiaoming | NiuJin | England | | 1003 | xiaoming | chaoyang street | Beijing | | 1004 | xiaohua | haha street | Zhengzhou | +------+----------+-----------------+-----------+ 3 rows in set (0.00 sec)
相关文章
- Mysql初始化root密码和允许远程访问
- 【MySQL】性能优化之 straight_join
- mysql5.6采集数据插入出现MySQL server has gone away解决办法
- mysql之数据库备份与恢复
- MySQL数据库如何导入导出
- MySQL--执行mysql脚本及其脚本编写
- 连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
- Ruby on Rails 3 Can't connect to local MySQL server through socket '/tmp/mysql.sock' on linux
- Mysql:Error Code 1235,This version of MySQL doesn’t yet support ‘LIMIT & IN/ALL/ANY/SOME 错误解决
- 数据库基础之Mysql(3)mysql删除历史binlog
- mysql 有报错 ERROR! MySQL is not running, but lock file (/var/lock/subsys/mysql) exists
- MySQL内核月报 2015.01-TokuDB·特性分析· Optimize Table
- MySQL · 捉虫动态 · 唯一键约束失效
- 重新整理 mysql 基础篇————— 事务隔离级别[四]
- mysql常用基础操作语法(十)~~子查询【命令行模式】
- 猿创征文|Python基础——Visual Studio版本——第六章 MySQL操作
- mysql事务 mysql事务回滚 MySQL事务死锁 如何解除死锁 资金出入账
- CentOS+Nginx+PHP+MySQL详细配置(图解)
- Groonga开源搜索引擎——列存储做聚合,没有内建分布式,分片和副本是随mysql或者postgreSQL作为存储引擎由MySQL自身来做分片和副本的
- mysql event 学习
- mysql设置远程访问权限
- Mysql之mysql工具
- golang操作mysql数据库(Go-SQL-Driver/MySQL)
- Mysql基础篇之索引上--04