mysql常见问题
select * from table where id IN (3,6,9,1,2,5,8,7) order by field(id,3,6,9,1,2,5,8,7);
MYSQL使用group by时，查询结果的总记录数
SELECT COUNT(*) FROM (SELECT COUNT(*) FROM tb_lm_channel_everytj GROUP BY `date` ) a ;
mysql 替换某个字段里相同之处的字符 简化版
UPDATE tb_charpter SET charpterName = REPLACE ( charpterName,‘a‘ ‘b‘ ) WHERE bid = 30105；
mysql 替换某个字段里相同之处的字符
UPDATE tb_charpter SET charpterName = REPLACE ( charpterName, substring( charpterName, locate(‘（‘, charpterName), locate(‘）‘, charpterName) - locate(‘（‘, charpterName) + 1 ), ‘‘ ) WHERE bid = 30105
原文：https://www.cnblogs.com/binblogs/p/11445590.html