MySQL-এ "Jone Deo" বা "Deo Jone" একক কোয়েরি দিয়ে বের করা

এজন্য LIKE ক্লজ ব্যবহার করুন।

টেবিল তৈরি করা

mysql> create table DemoTable 
-> ( 
-> ClientName varchar(100) 
-> ); 
Query OK, 0 rows affected (0.85 sec)

রেকর্ড ইনসার্ট করা

mysql> insert into DemoTable values('John Smith'); 
Query OK, 1 row affected (0.15 sec) 
mysql> insert into DemoTable values('Smith John'); 
Query OK, 1 row affected (0.18 sec) 
mysql> insert into DemoTable values('Jone Deo'); 
Query OK, 1 row affected (0.17 sec) 
mysql> insert into DemoTable values('Deo Jone'); 
Query OK, 1 row affected (0.14 sec) 
mysql> insert into DemoTable values('Chris Brown'); 
Query OK, 1 row affected (0.15 sec)

সকল রেকর্ড প্রদর্শন

mysql> select *from DemoTable;

আউটপুট

+-------------+ 
| ClientName  | 
+-------------+ 
| John Smith  | 
| Smith John  | 
| Jone Deo    | 
| Deo Jone    | 
| Chris Brown | 
+-------------+ 
5 rows in set (0.00 sec)

"Jone Deo" বা "Deo Jone" বের করার কোয়েরি

mysql> select *from DemoTable 
-> where ClientName 
-> LIKE 
-> (SELECT SUBSTRING_INDEX("%Jone% %Deo%", " ", -1)) 
-> or 
-> (SELECT SUBSTRING_INDEX("%Deo% %Jone%", " ", 1));

আউটপুট

+------------+ 
| ClientName | 
+------------+ 
| Jone Deo   | 
| Deo Jone   | 
+------------+ 
2 rows in set (0.00 sec)