mysql动态查询条件

$sql = "SELECT * FROM user WHERE name LIKE '%".$name."%' AND age LIKE '%".$age."%' AND sex LIKE '%".$sex."%' ORDER BY id ASC

仔细看看吧 相信你能看懂的。

-----------------------------------------------------------

楼主..模糊查询的条件为空的时候是完全匹配的。

$sql = "SELECT * FROM user WHERE name LIKE '%%' AND age LIKE '%%' AND sex LIKE '%%' ORDER BY id ASC

下面这样子才是空值 搜不到任何东西的。

$sql = "SELECT * FROM user WHERE name LIKE '% %' AND age LIKE '% %' AND sex LIKE '% %' ORDER BY id ASC

你再仔细看看 区别 多试试...我用这么久还没见过他不好使呢。。

select * from table where (name1 like '%key1%' or name2 like '%key2%' or name3 like '%key3%')

同理，你还可以任意再次组合，用or连接就行

如再上 name1 like key1 or name1 like key2 or name1 like key3

name2 like key1 or name2 like key2 or name2 like key3

等等

---