MySQL 查询显示使用 LIKE 过滤的表中的记录(包含多个单词)?
mysqlmysqli database
为此，请使用 RLIKE 并按照以下语法过滤记录 &Minus;
select * from yourTableName where yourColumnName rlike 'yourValue1|yourValue2';
首先我们创建一个表 −
mysql> create table DemoTable1935 ( Subject varchar(20) ); Query OK, 0 rows affected (0.00 sec)
使用 insert 命令在表中插入一些记录 −
mysql> insert into DemoTable1935 values('MySQL');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1935 values('Python');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1935 values('MongoDB');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1935 values('SQL Server');
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1935 values('PL SQL');
Query OK, 1 row affected (0.00 sec)
使用 select 语句显示表中的所有记录 −
mysql> select * from DemoTable1935;
这将产生以下输出 −
+------------+ | Subject | +------------+ | MySQL | | Python | | MongoDB | | SQL Server | | PL SQL | +------------+ 5 rows in set (0.00 sec)
这是过滤记录的查询:
mysql> select * from DemoTable1935 where Subject rlike 'SQL|Python';
这将产生以下输出 −
+------------+ | Subject | +------------+ | MySQL | | Python | | SQL Server | | PL SQL | +------------+ 4 rows in set (0.00 sec)
