mysql in/no in/like

最新推荐文章于 2024-05-30 16:53:35 发布

weixin_30668887

最新推荐文章于 2024-05-30 16:53:35 发布

阅读量126

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/perl6/p/7057625.html

版权

% 任意字符

_ 任意一个字符

in (value,......) 在这里

not in (value,......) 不在这里

mysql> select 'a' not in (1,2,3,'aa');
+-------------------------+
| 'a' not in (1,2,3,'aa') |
+-------------------------+
|                       1 |
+-------------------------+
1 row in set, 1 warning (0.00 sec)

mysql> select 'a'  in (1,2,3,'aa');
+----------------------+
| 'a'  in (1,2,3,'aa') |
+----------------------+
|                    0 |
+----------------------+
1 row in set, 1 warning (0.00 sec)

mysql> select 'a' like '_';
+--------------+
| 'a' like '_' |
+--------------+
|            1 |
+--------------+
1 row in set (0.00 sec)

mysql> select 'a' like '_a';
+---------------+
| 'a' like '_a' |
+---------------+
|             0 |
+---------------+
1 row in set (0.00 sec)

mysql> select 'a' like '%a';
+---------------+
| 'a' like '%a' |
+---------------+
|             1 |
+---------------+
1 row in set (0.00 sec)

mysql>

转载于:https://www.cnblogs.com/perl6/p/7057625.html