SQL?е???????
???????????? ???????[ 2016/10/20 11:40:30 ] ????????SQL ??????
??????д????????Oracle???????????????Oracle?е?????“’”???????????????“’”??????????????????????????????????????????????λ??“%”??“_”???
???????????????Oracle?в?????????????“’”?????“%”??“_”????????÷?б??“”???????????????????б??“”??????????
??????????tb??????col?????col?в??????“%”??“_”???????Σ?sql???£?
????-- Oracle
????select * from tb where col like '%\%%' or col like '%\_%' escape ''
????sql??“escape”??????????б??“”??????????????“”???“%”???“%”????????????????“%”??????????λ????
???????“%”??“_”????λ??????????where????????select ‘%’ from dual??????????
??????MySQL???????С??????MySQL????д“escape”????????÷?б??“”???????
????-- MySQL
????select * from tb where col like '%\%%' or col like '%\_%'
???????????????μ?????“’”?????????Oracle????????????????“’”?????????“’”????????????MySQL?п???????????“’”???б??“”?????????“’”??????????
????sql???£?
-- Oracle
select '''' from dual;
select * from tb where col like '%''%'
-- MySQL
select '''' from dual;
select * from tb where col like '%''%'
-- or
select ''' from dual;
select * from tb where col like '%'%'
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11