select * from 表 where length(字段)-length(replace(字段, '字符', ''))=1 --出现1次 转载于:https://www.cnblogs.com/ileaves/p/5753701.html