MariaDB社区

标题: mysql连表全文检索问题 [打印本页]

作者: yongqiang126 时间: 2010-8-27 17:19
标题: mysql连表全文检索问题
有两个表 businessesinformation和location，sql语句如下
SELECT location.location_name,businessesinformation.businesses_id,businessesinformation.businesses_logo,businessesinformation.businesses_contacename,businessesinformation.businesses_briefdes,businessesinformation.businesses_website,businessesinformation.businesses_address,businessesinformation.businesses_telephone FROM `businessesinformation`,`location` where MATCH(businesses_address,businesses_postal,location_name) AGAINST ('beijing' IN BOOLEAN MODE) and 1=1 and businessesinformation.businesses_country=location.location_id Limit 0,10
这个语句能够成功执行，不过老是提示一个错误
error inserting: Unknown column 'location_name' in 'where clause'
总是提示location_name这个列没有确定
把location_name换成location.location_name也报错！
哪位高手能帮忙解决下。谢谢！

作者: kider 时间: 2010-8-31 11:44
跟你的表结构，好好检查一下字段名及fulltext索引先...
把括号里的location_name也加个表名试试

作者: yongqiang126 时间: 2010-9-6 10:14
这个问题已经解决了
谢谢了
其实这条语句没有问题，出错的是另一条语句！

欢迎光临 MariaDB社区 (http://123.56.88.72/)