#是否包含某串select * from? table? tt where locate('7',tt.col)>0#替换UPDATE table?? SET col=REPLACE(col, '_27', '')