SELECT '1002#10131#15#15#' INTO @t; SELECT LENGTH(@t)-LENGTH(REPLACE(@t,'#','')) SELECT @t,; SELECT '1002#10131#15#15#', LENGTH('1002#10131#15#15#')-LENGTH(REPLACE('1002#10131#15#15#','#',''))
select length(field1)-length(replace(field1,'#','')) from test;
56,677
社区成员
56,708
社区内容
加载中
试试用AI创作助手写篇文章吧