mysql表格多字段搜索

SELECT * FROM `add` WHERE `new` = '文章' and `a7` like '中国' or `a7` like '美国' ORDER BY `id` DESC LIMIT 0 , 5

怎样写才是最正确的表格多字符段搜索，高手请示

作者: liyuqa 发布时间: 2011-05-05

SELECT * FROM `add` WHERE `new` = '文章' and (`a7` like '%中国%' or `a7` like '%美国%') ORDER BY `id` DESC LIMIT 0 , 5

作者: xuzuning 发布时间: 2011-05-05