热门标签
更多>
搜索结果
查询Tags标签： 0809，共有 2条记录-
mysql每日一题0809--每行包含某个特定数据或者字符 like regex like length
测试数据 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)solution select * from T0809 where LENGTH(data)-LENGTH(replace(data,8,)) <2 and LENGTH(data)-LENGTH(replace(dat…
2021/8/10 19:35:37 人评论 次浏览 -
mysql每日一题0809--每行包含某个特定数据或者字符 like regex like length
测试数据 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)solution select * from T0809 where LENGTH(data)-LENGTH(replace(data,8,)) <2 and LENGTH(data)-LENGTH(replace(dat…
2021/8/10 19:35:37 人评论 次浏览
