Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
MySQL LIKE IN()?
You can implement MySQL Like IN() with the help of Regular Expression (regexp) as well. The syntax is as follows −
select *from yourTableName where yourColumName regexp ‘value1|value2|value3……|valueN’;
To understand the above logic, you need to create a table. Let us first create a table −
mysql> create table INDemo -> ( -> Id int, -> Name varchar(100) -> ); Query OK, 0 rows affected (0.90 sec)
Insert some records into the table. The query is as follows −
mysql> insert into INDemo values(100,'John'); Query OK, 1 row affected (0.13 sec) mysql> insert into INDemo values(104,'Carol'); Query OK, 1 row affected (0.18 sec) mysql> insert into INDemo values(108,'David'); Query OK, 1 row affected (0.19 sec) mysql> insert into INDemo values(112,'Smith'); Query OK, 1 row affected (0.12 sec) mysql> insert into INDemo values(116,'Johnson'); Query OK, 1 row affected (0.17 sec) mysql> insert into INDemo values(120,'Sam'); Query OK, 1 row affected (0.16 sec)
Now we can display all the records with the help of SELECT statement. The query is as follows −
mysql> select *from INDemo;
The following is the output −
+------+---------+ | Id | Name | +------+---------+ | 100 | John | | 104 | Carol | | 108 | David | | 112 | Smith | | 116 | Johnson | | 120 | Sam | +------+---------+ 6 rows in set (0.00 sec)
Use regexp that works like IN(). You can apply the above syntax which I have discussed in the beginning. The query is as follows −
mysql> select *from INDemo where Id regexp '112|116|100';
The following is the output −
+------+---------+ | Id | Name | +------+---------+ | 100 | John | | 112 | Smith | | 116 | Johnson | +------+---------+ 3 rows in set (0.21 sec)
You will get the same output with IN(). Now, let us check it with the help of IN(). The query is as follows −
mysql> select *from INDemo where Id IN(112,116,100);
Here is the output
+------+---------+ | Id | Name | +------+---------+ | 100 | John | | 112 | Smith | | 116 | Johnson | +------+---------+ 3 rows in set (0.00 sec)
As you can see in the above output, we are getting the same result.
1K+ Views
