pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%, 
ÀýÈç:TABLE a
columnA
'222'
'33%44'

ÈçºÎ²éѯ±íaÖÐcolumnA×Ö¶ÎÖÐÄÄЩÐаüº¬'%'

лл

---

select * from a
where columna like '%/%%' escape '/'

---

UP

---

SELECT * from a WHERE columnA LIKE '%\%%' ESCAPE'\';

ÆäÖУ¬ESCAPE'\'±íʾ£º\Ϊ»»Âë×Ö·û£¬Æ¥Åä´®ÖиúÔÚ\ºóÃæµÄ×Ö·û%²»ÔÙ¾ßÓÐͨÅä·ûµÄº¬Ò壻
תÒåΪÆÕͨµÄ¡°%¡±×Ö·û¡£

---

ÒýÓÃ

select * from a
where columna like '%/%%' escape '/'

UP

---

Â¥Éϵķ½·¨¹ÜÓ㬵«ÊÇżÏëÎÊÒ»¸öÈç¹û×Ö·û´®Àï°üº¬ÓÐ'£¨µ¥ÒýºÅ£©µÄÒªÔõôÓÃLike²éѯ°¡£¿£¿

---

select * from t1 where instr(f1,'%') != 0 ;

---

ÓÃÕýÔò±í´ïʽ°É£º
select * from dual
where 'tian%dd'like '%/%%' escape '/';

---

ÒýÓÃ

Â¥Éϵķ½·¨¹ÜÓ㬵«ÊÇżÏëÎÊÒ»¸öÈç¹û×Ö·û´®Àï°üº¬ÓÐ'£¨µ¥ÒýºÅ£©µÄÒªÔõôÓÃLike²éѯ°¡£¿£¿

select * from t1 where instr(f1,'''') != 0;

---

ÒýÓÃ

Â¥Éϵķ½·¨¹ÜÓ㬵«ÊÇżÏëÎÊÒ»¸öÈç¹û×Ö·û´®Àï°üº¬ÓÐ'£¨µ¥ÒýºÅ£©µÄÒªÔõôÓÃLike²éѯ°¡£¿£¿

where col1 like '%''%'
»ò
where col1 like '%'||chr(39)||'%'
»ò
where instr(col1,chr(39))>0

---

Â¥Ö÷ÓÃOracle ÕýÔòÊÔÊÔ
SQL code:

with tt as (
select '33%44''' COL from dual
)

select * from