Home  >  Article  >  Database  >  SQL判断一上指定字符串在字段中出现的次数

SQL判断一上指定字符串在字段中出现的次数

WBOY
WBOYOriginal
2016-06-07 14:57:331464browse

无详细内容 无 这里提取指定符串"A"在字段中的出现次数SQL为: select len(keyword)-len(replace(keyword, 'A', ' ')) from 表

这里提取指定符串"A"在字段中的出现次数SQL为:
 
 select len(keyword)-len(replace(keyword, 'A', ' ')) from 表
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn