OracleÖвéѯÒÔA»òB¿ªÍ·µÄÐÕÃû

OracleÊDz»ÊDz»Ö§³ÖÒÔϵÄд·¨£º

    1.  select * from emp where ename like '[ABC]%';

    2.  select * from emp where ename like '[A-D]%';

    3.  select * from emp where ename like '%[%]%';


      ÎÒ´ÓOracle 10gÖÐÖ´ÐÐÉÏÃæ3¸öÓï¾ä¶¼·µ»Ø 0 ÐУ¬ÔÚSQLServerÖÐÊÇ¿ÉÒÔÖ´Ðеġ£
ÒªÊÇOracleÖв»Ö§³ÖÕâÖÖд·¨µÄ»°£¬ÄÇôҪÍê³ÉÈçÉϱߵÚÒ»¾äµÄ¹¦ÄÜ£¬¼´Òª²éѯÃû×Ö
ÒÔ A »ò B »ò C ¿ªÍ·µÄÈË£¬SQLÓï¾ä¸ÃÔõôд²ÅºÃ¡£

---

select * from emp where ename like 'A%';
select * from emp where ename like 'B%';
select * from emp where ename like 'C%';

---

  ´ËÍ⻹¿ÉÒÔÓÃstarting with....

---

select * from TABLE_NAME where substr(NAME,1,1) in ('A','B');

---

ÒýÓÃ

select * from TABLE_NAME where substr(NAME,1,1) in ('A','B');

¶¥Â¥Éϵģ¬ÕâÑùЧÂʸߺܶà

---

select * from emp where ename REGEXP_LIKE(ename,'^[ABC]')

---

ѧϰÁË¡£

---

ÒýÓÃ

select * from TABLE_NAME where substr(NAME,1,1) in ('A','B');

---

ÒýÓÃ

select * from emp where ename REGEXP_LIKE(ename,'^[ABC]')

regexp_like ÊÇʲôÒâ˼£¿£¿

---

ÒýÓÃ

regexp_like ÊÇʲôÒâ˼£¿£¿<