English | 简体中文 | 繁體中文 | Русский язык | Français | Español | Português | Deutsch | 日本語 | 한국어 | Italiano | بالعربية

A Simple Method to Implement Multi-Keyword Search Using PHP MySQL LIKE

Or called, word segmentation retrieval database

$res = mysql_query("select * from peter where id like '%Chinese herbal medicine%' and '%6%' //This is wrong to write;

$res = mysql_query("select * from peter where id like '%Chinese herbal medicine%' or '%6%' //And this is correct; strange~

 

$res = mysql_query("select * from peter where id like '%Chinese herbal medicine%' and id like '%6%' //This is correct to write;

$res = mysql_query("select * from peter where id like '%Chinese herbal medicine%' or id like '%6%' //This is all correct to write;

This is the full content of the method of implementing multi-keyword search in php mysql like brought to you by the editor. Hope everyone will support and cheer for the tutorial~

You May Also Like