我想获取字段: title 中 + 的个数,使用下面的语句:
select title, LENGTH(title)- LENGTH(REPLACE(title,"+","")) from cms_resources where type_name="备课综合"
判断 title 中 + 号为2的查询语句为:
select title, LENGTH(title)- LENGTH(REPLACE(title,"+","")) from cms_resources
where type_name="备课综合" and LENGTH(title)- LENGTH(REPLACE(title,"+",""))=1