????????????????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]??'??????е???????