我正在尝试创建一个很好的小搜索语句,根据返回的内容使用不同的搜索项来搜索多个字段。我基本上是在设置我想要搜索的顺序,如果找不到一个搜索词,请尝试下一个。但是,我使用WHERE子句来分离搜索一种类型的数据。目前我得到了一些奇怪的结果,因为我不认为我的顺序是正确的,似乎我的WHERE子句被忽略了。
下面是我的声明(我是usig PHP):
mysql_query("SELECT * FROM item AS i LEFT JOIN country AS c ON i.country_id = c.country_id WHERE i.item_status = 'active' AND (i.item_name LIKE '%".$_SESSION['item']."%') OR i.item_description LIKE '%".$_SESSION['description']."%' OR i.item_name LIKE '%".$_SESSION['description']."%' "); 提前谢谢你。
发布于 2010-10-07 21:18:32
为什么不使用全文搜索功能呢?
需要为create fulltext search index更改表结构。
ALTER TABLE item ADD FULLTEXT (item_name, item_description);然后,您的查询将变为:
mysql_query("
SELECT * FROM item AS i LEFT JOIN country AS c ON i.country_id = c.country_id
WHERE i.item_status = 'active' AND
MATCH (i.item_name, i.item_description)
AGAINST (" . $_SESSION['item'] . " " . $_SESSION['description'] . ");
");简单、准确、快速。
发布于 2010-10-07 05:01:40
将右括号移到语句的末尾:
SELECT *
FROM item AS i LEFT JOIN country AS c
ON i.country_id = c.country_id
WHERE i.item_status = 'active'
AND (i.item_name LIKE '%".$_SESSION['item']."%'
OR i.item_description LIKE '%".$_SESSION['description']."%'
OR i.item_name LIKE '%".$_SESSION['description']."%')发布于 2010-10-07 05:03:00
是你的括号放错了地方。下面是正确的代码:
mysql_query("SELECT * FROM item AS i LEFT JOIN country AS c ON i.country_id = c.country_id WHERE i.item_status = 'active' AND (i.item_name LIKE '%".$_SESSION['item']."%' OR i.item_description LIKE '%".$_SESSION['description']."%' OR i.item_name LIKE '%".$_SESSION['description']."%')");https://stackoverflow.com/questions/3876811
复制相似问题