with b as ( select '啊啊123网吧' A from dual union all select '拜拜12网吧' from dual union all select '猜猜1网吧' from dual union all select '淡定网吧' from dual )select A from b where REGEXP_SUBSTR(A,'[1-9]',1)>0
问个问题就说清楚点好么,谁知道你为什么要查出啊啊123网吧啊 with b as (select '啊啊123网吧' A from dual union all select '拜拜12网吧' from dual union all select '猜猜1网吧' from dual union all select '淡定网吧' from dual) select A from b where REGEXP_count(A, '\d') = 3
with b as ( select '啊啊123网吧' A from dual union all select '拜拜12网吧' from dual union all select '猜猜1网吧' from dual union all select '淡定网吧' from dual )select A from b where REGEXP_SUBSTR(A,'[3]',1)>0
WITH b AS (SELECT '啊啊123网吧' a FROM dual UNION ALL SELECT '拜拜1234网吧' FROM dual UNION ALL SELECT '123猜猜1网吧222' FROM dual UNION ALL SELECT '123淡定网吧123' FROM dual) SELECT a FROM b WHERE regexp_instr(a, '[^0-9]\d{3}网吧', 1) > 0;
WITH b AS (SELECT '啊啊123网吧' a FROM dual UNION ALL SELECT '拜拜1234网吧' FROM dual UNION ALL SELECT '123猜猜1网吧222' FROM dual UNION ALL SELECT '123淡定网吧123' FROM dual) SELECT a FROM b WHERE regexp_instr(a, '\d{3}', 1) > 0;
--测试数据 WITH b AS (SELECT '啊啊123网吧' a FROM dual UNION ALL SELECT '拜拜1234网吧' FROM dual UNION ALL SELECT '猜猜1网吧22' FROM dual UNION ALL SELECT '淡定网吧' FROM dual)--SQL SELECT a FROM b WHERE regexp_like(a, '[[:digit:]]{3}') --result:啊啊123网吧 拜拜1234网吧
(
select '啊啊123网吧' A from dual
union all
select '拜拜12网吧' from dual
union all
select '猜猜1网吧' from dual
union all
select '淡定网吧' from dual
)select A from b where REGEXP_SUBSTR(A,'[1-9]',1)>0
with b as
(select '啊啊123网吧' A
from dual
union all
select '拜拜12网吧'
from dual
union all
select '猜猜1网吧'
from dual
union all
select '淡定网吧' from dual)
select A from b where REGEXP_count(A, '\d') = 3
(
select '啊啊123网吧' A from dual
union all
select '拜拜12网吧' from dual
union all
select '猜猜1网吧' from dual
union all
select '淡定网吧' from dual
)select A from b where REGEXP_SUBSTR(A,'[3]',1)>0
(SELECT '啊啊123网吧' a
FROM dual
UNION ALL
SELECT '拜拜1234网吧'
FROM dual
UNION ALL
SELECT '123猜猜1网吧222'
FROM dual
UNION ALL
SELECT '123淡定网吧123'
FROM dual)
SELECT a
FROM b
WHERE regexp_instr(a, '[^0-9]\d{3}网吧', 1) > 0;
WITH b AS
(SELECT '啊啊123网吧' a
FROM dual
UNION ALL
SELECT '拜拜1234网吧'
FROM dual
UNION ALL
SELECT '123猜猜1网吧222'
FROM dual
UNION ALL
SELECT '123淡定网吧123'
FROM dual)
SELECT a
FROM b
WHERE regexp_instr(a, '\d{3}', 1) > 0;
麻烦你再费心,看看这条select语句怎么写。。谢谢了,在线等。
--测试数据
WITH b AS
(SELECT '啊啊123网吧' a
FROM dual
UNION ALL
SELECT '拜拜1234网吧'
FROM dual
UNION ALL
SELECT '猜猜1网吧22'
FROM dual
UNION ALL
SELECT '淡定网吧'
FROM dual)--SQL
SELECT a
FROM b
WHERE regexp_like(a, '[[:digit:]]{3}')
--result:啊啊123网吧
拜拜1234网吧