MySQL-এ দুটি LIKE স্টেটমেন্ট OR অপারেটরসহ কীভাবে ব্যবহার করবেন?

MySQL-এ দুটি LIKE শর্ত OR অপারেটর দিয়ে जोড়া দেওয়া যায়।

সিনট্যাক্স

SELECT * FROM yourTableName WHERE (yourColumnName LIKE '%yourValue1%' OR yourColumnName LIKE '%yourValue2%') AND yourColumnName = yourValue;

উদাহরণ

একটি টেবিল তৈরি করি:

mysql> create table ORLikeDemo 
    -> ( 
    -> Id int not null auto_increment, 
    -> FirstName varchar(15), 
    -> LastName varchar(15), 
    -> Primary Key(Id) 
    -> ); Query OK, 0 rows affected (1.19 sec)

রেকর্ড যোগ করি:

mysql> insert into ORLikeDemo(FirstName,LastName) values('John','Smith'); 
mysql> insert into ORLikeDemo(FirstName,LastName) values('Carol','Taylor'); 
mysql> insert into ORLikeDemo(FirstName,LastName) values('John','Doe'); 
mysql> insert into ORLikeDemo(FirstName,LastName) values('Bob','Jones'); 
mysql> insert into ORLikeDemo(FirstName,LastName) values('David','Miller'); 
mysql> insert into ORLikeDemo(FirstName,LastName) values('Mike','Williams'); 
mysql> insert into ORLikeDemo(FirstName,LastName) values('Sam','Taylor');

সকল রেকর্ড

mysql> select *from ORLikeDemo;

আউটপুট

+----+-----------+----------+
| Id | FirstName | LastName |
+----+-----------+----------+
|  1 | John      | Smith    |
|  2 | Carol     | Taylor   |
|  3 | John      | Doe      |
|  4 | Bob       | Jones    |
|  5 | David     | Miller   |
|  6 | Mike      | Williams |
|  7 | Sam       | Taylor   |
+----+-----------+----------+
7 rows in set (0.00 sec)

দুটি LIKE OR দিয়ে কোয়েরি

mysql> select *from ORLikeDemo where (LastName like '%Smith%' OR LastName like'%Doe%') AND Id = 3;

ফলাফল

+----+-----------+----------+
| Id | FirstName | LastName |
+----+-----------+----------+
|  3 | John      | Doe      |
+----+-----------+----------+
1 row in set (0.03 sec)