我尝试了这个查询,
$str =$_POST['val'].'%';
$query = mysql_query("select * from table WHERE title LIKE '$str' ORDER BY createdtime DESC LIMIT 0, 70 ");
但它只在单词的开头搜索匹配项。不要搜索世界上其他地方。例如,当我在单词"golden"中搜索模式"gold"时,它检测正确。但不是在中间或结尾或其他地方,像"黄金"或"黄金"这样的词不会正确显示。
$query = mysql_query("select * from table WHERE title LIKE '%$str%' ORDER BY createdtime DESC LIMIT 0, 70 ");
您需要通过%word%
。
$str =$_POST['val'];
$query = mysql_query("select * from table WHERE title LIKE '%$str%' ORDER BY createdtime DESC LIMIT 0, 70 ");