如果不是bbb,是一个字符串变量str呢,我用:
select * from aaa where (code like '%quotedstr(str)%') or (name like '%quotedstr(str)%') or (address like '%quotedstr(str)%')or( momo like '%quotedstr(str)%')
不行!
select code,name,address,telephone,momo
from aaa
where
(code like '%bbb%') or(name like '%bbb%') or (address like '%bbb%') or (telephone like '%bbb%') or (mome like '%bbb%')