需要对输入值进行一下处理-- 方法一,对输入顺序有要求,如mp3+空格+bai就不行 SELECT * FROM 表 WHERE uri LIKE '%bai%mp3%' AND filename LIKE '%bai%mp3%' AND number LIKE '%bai%mp3%' -- 方法二 SELECT * FROM 表 WHERE uri LIKE '%bai%' AND filename LIKE '%bai%' AND number LIKE '%bai%' AND uri LIKE '%mp3%' AND filename LIKE '%mp3%' AND number LIKE '%mp3%'
SELECT * FROM 表 WHERE uri LIKE '%bai%mp3%' AND filename LIKE '%bai%mp3%' AND number LIKE '%bai%mp3%'
-- 方法二
SELECT * FROM 表 WHERE uri LIKE '%bai%' AND filename LIKE '%bai%' AND number LIKE '%bai%' AND uri LIKE '%mp3%' AND filename LIKE '%mp3%' AND number LIKE '%mp3%'
... regexp 'bai.*mp[34]'
字段之间似乎应该用or,不应该用and