mysql,同时查询问题？

select MTAUT_ID,MTAUT_INDEX,MTAUT_PARID from MT005AUT where MTAUT_PARID like '%,%,%' and MTAUT_PARID in ('MT10000')

想同时查询mtaut_parid里有2个逗号，还得有mt10000字符串，这个语法看来不对？

试试like '%","%","%'

你查查看不就知道了，SQL写出来了还问

select MTAUT_ID,MTAUT_INDEX,MTAUT_PARID from MT005AUT where MTAUT_PARID like '%,%,%' and MTAUT_PARID like '%MT10000'%

select MTAUT_ID,MTAUT_INDEX,MTAUT_PARID from MT005AUT where MTAUT_PARID regexp ',｛2｝' and MTAUT_PARID regexp 'MT10000｛1,｝'

select MTAUT_ID,MTAUT_INDEX,MTAUT_PARID from MT005AUT where MTAUT_PARID = 'MT10000' and MTAUT_PARID like '%,%,%'