????????????????SQL?????????????????????????????????:
?????????????????????????????????????? ??????????????锟�? SELECT ??? FROM ?? WHERE ???? LIKE ????
???????泄?????????SQL???????????????
????1??% ?????????0????????????????????????????????????些????????????????????????????%%???????
???????? SELECT * FROM [user] WHERE u_name LIKE '%??%'?????u_name?“????”??“??猫??”??“????猫”??“??????”?????“??”????????????
????????????????u_name?屑???“??”????“猫”???????????and????SELECT * FROM [user] WHERE u_name LIKE '%??%' AND u_name LIKE '%猫%'
??????????SELECT * FROM [user] WHERE u_name LIKE '%??%猫%'???????????“????猫”????????????????????????“??猫??”??
?????????%??????????????%??????????%??%?????????????
????2??_ ?? ???????????????????????????????????????????????????????
???????? SELECT * FROM [user] WHERE u_name LIKE '_??_'????“??????”??????u_name??????????屑????????“??”???
?????????? SELECT * FROM [user] WHERE u_name LIKE '??__'????“????猫”????name?????????????????“??”???
????3??[ ] ???????????????????械???????????????????????????????????????围???????????????????械????????
????????SELECT * FROM [user] WHERE u_name LIKE '[??????]??'?????“????”??“????”??“????”????????“????????”????
??????????[ ] ?????????????01234??abcde??????????写?“0-4”??“a-e”SELECT * FROM [user] WHERE u_name LIKE '??[1-9]'?????“??1”??“??2”??……??“??9”??
??????????“-”????????????位??'????[-1-9]'??
????Oracle 10g?????姹�?梅????
????select * from flow_user where regexp_like(username?? '[??????]??')
????4??[^ ] ??????????????????????????????????? [] ??????????????????????????????????????????
????????SELECT * FROM [user] WHERE u_name LIKE '[^??????]??'?????????“??”??“??”??“??”??“????”??“????”????????? SELECT * FROM [user] WHERE u_name LIKE '??[^1-4]'?????“??1”??“??4”?????“??5”??“??6”??……??“??9”??
???????oracle like ????????????????????like??????regexp_like
????5?????????????????
????* ???????????????????????select * from tbl_user
???????????????????????????????????“%”??“_”??“[”?????????????????????????????“[ ]”??????????????????????写????????????function sqlencode(str)str=replace(str??"["??"[[]") '??????????str=replace(str??"_"??"[_]")str=replace(str??"%"??"[%]")sqlencode=strend function
?????????????????????????????煤??????????????????????????????????????????????????????? Select * FROM user Where name LIKE '??[^1-4]'
???????? ??'????[^1-4]??'??????械???????