MySQL query to display records from a table filtered using LIKE with multiple words?

MySQLMySQLi Database

For this, use RLIKE and filter records as in the below syntax &Minus;

select * from yourTableName
   where yourColumnName rlike 'yourValue1|yourValue2';

Let us first create a table −

mysql> create table DemoTable1935
   (
   Subject varchar(20)
   );
Query OK, 0 rows affected (0.00 sec)

Insert some records in the table using insert command −

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)

Display all records from the table using select statement −

mysql> select * from DemoTable1935;

This will produce the following output −

+------------+
| Subject    |
+------------+
| MySQL      |
| Python     |
| MongoDB    |
| SQL Server |
| PL SQL     |
+------------+
5 rows in set (0.00 sec)

Here is the query to filter records:

mysql> select * from DemoTable1935
   where Subject rlike 'SQL|Python';

This will produce the following output −

+------------+
| Subject    |
+------------+
| MySQL      |
| Python     |
| SQL Server |
| PL SQL     |
+------------+
4 rows in set (0.00 sec)
raja
Published on 30-Dec-2019 07:47:34
Advertisements