Home > Article > Backend Development > php mysql like method to implement multi-keyword search
This article mainly introduces the method of implementing multi-keyword search in php mysql like. Interested friends can refer to it. I hope it will be helpful to everyone.
Or called, word segmentation search database
$res = mysql_query("select * from peter where id like '%Chinese herbal medicine%' and '%6%'") ; //Writing like this is an error;
$res = mysql_query("select * from peter where id like '%中文字幕%' or '%6%'"); //Writing like this is correct ; Strange~
$res = mysql_query("select * from peter where id like '%中文字幕%' and id like '%6%'"); //This is correct to write ;
$res = mysql_query("select * from peter where id like '%中文字幕%' or id like '%6%'"); //Writing this way is correct;
The above is the entire content of this article, I hope it will be helpful to everyone's study.
Related recommendations:
How to read large CSV files with PHP and import them into the database
phpMethod to implement DES encryption and decryption consistent with c
#PHP practical tutorial methods of filtering, verification, escaping and password
The above is the detailed content of php mysql like method to implement multi-keyword search. For more information, please follow other related articles on the PHP Chinese website!