mysql连表全文检索问题

yongqiang126

有两个表 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

跟你的表结构，好好检查一下字段名及fulltext索引先...
把括号里的location_name也加个表名试试

yongqiang126

这个问题已经解决了
谢谢了
其实这条语句没有问题，出错的是另一条语句！