select col_name from tab_name where col_name like '%a%' or like '%b%'order by col_name asc
select col_name from tab_name where find_in_set(col_name 'a,b');
select col_name from tab_name where col_name like '%a%' or like '%b%' 相当于 select col_name from tab_name where col_name like '%a%'
to foolbirdflyfirst(湖水清澈): select col_name from tab_name where col_name like '%a%' or like '%b%'是错的,我写错了,应该是: select col_name from tab_name where col_name like '%a%' or col_name like '%b%'
to underone(再看抽你小丫的): select col_name from tab_name where col_name like '%a%' or like '%b%'order by col_name asc 这样不行的,我只是举个例子用like搜索a和b,实际上比较肯定是搜索中文,而且比较复杂一下。
to yueliangdao0608((深圳PHPER&&MYSQLER)骑上帝他老婆写程序): select col_name from tab_name where find_in_set(col_name 'a,b'); 老兄:这条差不多,但是只能精确匹配,不能模糊查询,我在手册里面找了半天也没有找到类似的函数,老兄有没有其他的办法?还请指教一下,谢谢啦
select col_name from tab_name where col_name like '%a%' or like '%b%'是错的,我写错了,应该是:
select col_name from tab_name where col_name like '%a%' or col_name like '%b%'
select col_name from tab_name where col_name like '%a%' or like '%b%'order by col_name asc
这样不行的,我只是举个例子用like搜索a和b,实际上比较肯定是搜索中文,而且比较复杂一下。
select col_name from tab_name where find_in_set(col_name 'a,b');
老兄:这条差不多,但是只能精确匹配,不能模糊查询,我在手册里面找了半天也没有找到类似的函数,老兄有没有其他的办法?还请指教一下,谢谢啦