如何在MySQL中使用逗号分隔的字符串来实现IN ()？

将逗号分隔的字符串设置为IN()函数中下面的语法：

select *from yourTableName where yourColumnName IN('yourCommaSeparatedValue');

让我们首先创建一个表−

mysql> create table DemoTable1314
-> (
-> Number varchar(100)
-> );
Query OK, 0 rows affected (0.53 sec)

使用INSERT命令将一些记录插入表中−

mysql> insert into DemoTable1314 values('45,67,89');
Query OK, 1 row affected (0.13 sec)
mysql> insert into DemoTable1314 values('10,20,50');
Query OK, 1 row affected (0.10 sec)
mysql> insert into DemoTable1314 values('90,56,45');
Query OK, 1 row affected (0.23 sec)

使用SELECT语句显示表中的所有记录−

mysql> select *from DemoTable1314;

阅读更多：MySQL 教程

输出

+----------+
| Number   |
+----------+
| 45,67,89 |
| 10,20,50 |
| 90,56,45 |
+----------+
3 rows in set (0.00 sec)

以下是在MySQL中使用逗号分隔的字符串的查询语句IN()：

mysql> select *from DemoTable1314 where Number IN('10,20,50');

输出

+----------+
| Number   |
+----------+
| 10,20,50 |
+----------+
1 row in set (0.02 sec)