PHP mysql like implementation of multi-keyword search method

This article mainly introduces PHP mysql like implementation of multi-keyword search method, interested in the friend's reference, I hope to help you.

or call, Word Search database

$res = mysql_query ("SELECT * from the Peter where id like '% Herbal medicine% ' and '%6% '"); This is an error in writing;

$res = mysql_query ("SELECT * from the Peter where id like '% herbal medicine% ' or '%6% '"); And that's the right thing to say;

$res = mysql_query ("SELECT * from the Peter where id like '% Herbal medicine% ' and id like '%6% '"); This is the right way to write;

$res = mysql_query ("SELECT * from the Peter where id like '% herbal medicine% ' or id like '%6% '"); It's all right to write;

The above is the whole content of this article, I hope that everyone's study has helped.