SQL?????????????????????
???????????? ???????[ 2017/4/7 10:52:36 ] ????????????? SQL
????????????????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]??'??????械???????
??????

???路???
??????????????????
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