---
title: "查找表中某个字段下某字符出现次数为N次的记录"
author: "java_frog"
date: "2010-12-03T13:17:19Z"
tags: []
categories: ["数据库"]
slug: "n"
draft: false
lastmod: "2010-12-03T13:17:19Z"
id: 832461
url: "https://java-frog.iteye.com/blog/832461"
---

这里主要用到length,

LENGTH(company)查出某记录这个字段总长度，
LENGTH(REPLACE(company,'/',''))将斜杠替换为空，注意不能为空格，查出除/为的字段长度，相减后得到/出现次数；
SELECT * FROM hr_rbg_working where LENGTH(company)-LENGTH(REPLACE(company,'/',''))=3
查/出现过3次的记录，非3次的不要