#统计字符串个数的sql语句 #SUM((LENGTH(content)-LENGTH(REPLACE(content, '123', '')))/LENGTH('123')) SELECT SUM((LENGTH(content)-LENGTH(REPLACE(content, '123', '')))/LENGTH('123')) as 'table_name表content字段中的字符串123的个数' from table_name;