|
|
有两个表 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也报错！
哪位高手能帮忙解决下。谢谢！
|
|
|Archiver|小黑屋|手机版|MariaDB社区
( 京ICP备07012489号 ) 
|
IP卡
狗仔卡
发表于 2010-8-27 17:19:37
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
转播
分享
淘帖
顶
踩
提升卡
置顶卡
沉默卡
喧嚣卡
变色卡
显身卡
楼主
发表于 2010-8-31 11:44:43