MySQL में दो LIKE स्टेटमेंट को OR कैसे करें?

दो 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'); 
Query OK, 1 row affected (0.13 sec)
mysql> INSERT INTO ORLikeDemo(FirstName, LastName) VALUES('Carol', 'Taylor'); 
Query OK, 1 row affected (0.23 sec)
mysql> INSERT INTO ORLikeDemo(FirstName, LastName) VALUES('John', 'Doe'); 
Query OK, 1 row affected (0.11 sec)
mysql> INSERT INTO ORLikeDemo(FirstName, LastName) VALUES('Bob', 'Jones'); 
Query OK, 1 row affected (0.20 sec)
mysql> INSERT INTO ORLikeDemo(FirstName, LastName) VALUES('David', 'Miller'); 
Query OK, 1 row affected (0.17 sec)
mysql> INSERT INTO ORLikeDemo(FirstName, LastName) VALUES('Mike', 'Williams'); 
Query OK, 1 row affected (0.11 sec)
mysql> INSERT INTO ORLikeDemo(FirstName, LastName) VALUES('Sam', 'Taylor'); 
Query OK, 1 row affected (0.14 sec)

सभी रिकॉर्ड देखें

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)