mysql每日一题0809--每行包含某个特定数据或者字符 like regex like length

onemorepoint

于 2021-08-10 18:35:00 发布

阅读量96

点赞数

分类专栏： mysql每日一题文章标签： mysql python 数据库 java 机器学习

本文链接：https://blog.youkuaiyun.com/onemorepoint/article/details/119589948

版权

12 篇文章

订阅专栏

CREATE TABLE T0809
(
ID INT,
DATA VARCHAR(10)
);

INSERT INTO T0809 VALUES(1,'8'),
(2,'88'),
(3,'7,8'),
(4,'6,7,8'),
(5,'8,9'),
(6,'7,88')

select *   from T0809 where 
LENGTH(data)-LENGTH(replace(data,'8','')) <2 
and LENGTH(data)-LENGTH(replace(data,'8',''))>0

SELECT t.*FROM t0809 tWHERE REGEXP_Count(t.data,8,1)=1