一个sql 条件的问题。

[NetVan]

sql="select * from member where use=0 and sh=0 and name Like '%"& keyword &"%' and province Like '%"& keyword &"%' and city Like '%"& keyword &"%' order by id desc"

use sh 是二个条件，这二个一定要是真

后面的条件是or 上面的是错的，下知道这种语句怎么写呀。

[OracleRoob]

sql="select * from member
where use=0 and sh=0
and (name Like '%"& keyword &"%' or province Like '%"& keyword &"%' or city Like '%"& keyword &"%')
order by id desc"

[mislrb]

sql="select * from member where use=0 and sh=0 and (name Like '%"& keyword &"%' or province Like '%"& keyword &"%' or city Like '%"& keyword &"%)' order by id desc"

[mislrb]

sql="select * from member where use=0 and sh=0 and (name Like '%"& keyword &"%' or province Like '%"& keyword &"%' or city Like '%"& keyword &"%') order by id desc"

[NetVan]

这样做也不对的呀。

[NetVan]

已经成功了。谢谢大家