SQLͨÅä·û¼°Ä£Ê½Æ¥Åä
Ç°Ìá,MS SQLµÄͨÅä·ûº¬Ò壺
ÐòºÅ
ͨÅä·û
º¬Òå
ʾÀý
1
%
°üº¬Áã¸ö»ò¶à¸ö×Ö·ûµÄÈÎÒâ×Ö·û´®¡£
WHERE title LIKE '%computer%' ½«²éÕÒÔÚÊéÃûÖÐÈÎÒâλÖðüº¬µ¥´Ê"computer" µÄËùÓÐÊéÃû¡£
2
_
Èκε¥¸ö×Ö·û¡£
WHERE au_fname LIKE '_ean' ½«²éÕÒÒÔ ean ½áβµÄËùÓÐ 4 ¸ö×ÖĸµÄÃû×Ö£¨Dean¡¢Sean µÈ£©¡£
3
[ ]
Ö¸¶¨·¶Î§ ([a-f]) »ò¼¯ºÏ ([abcdef]) ÖеÄÈκε¥¸ö×Ö·û¡£
WHERE au_lname LIKE '[C-P]arsen' ½«²éÕÒÒÔ arsen ½áβ²¢ÇÒÒÔ½éÓÚ C Óë P Ö®¼äµÄÈκε¥¸ö×Ö·û¿ªÊ¼µÄ×÷ÕßÐÕÊÏ£¬ÀýÈç Carsen¡¢Larsen¡¢Karsen µÈ¡£ÔÚ·¶Î§ËÑË÷ÖУ¬·¶Î§°üº¬µÄ×Ö·û¿ÉÄÜÒòÅÅÐò¹æÔòµÄÅÅÐò¹æÔò¶øÒì¡£
4
[^]
²»ÊôÓÚÖ¸¶¨·¶Î§ ([a-f]) »ò¼¯ºÏ ([abcdef]) µÄÈκε¥¸ö×Ö·û¡£
WHERE au_lname LIKE 'de[^l]%' ½«²éÕÒÒÔ de ¿ªÊ¼²¢ÇÒÆäºóµÄ×Öĸ²»Îª l µÄËùÓÐ×÷ÕßµÄÐÕÊÏ¡£
¶¨Òå²âÊÔ±í£º
create table EscapePattern(value varchar(100))
go
insert into EscapePattern
select 'aSQL'
union all select 'SQL'
union all select 'SQLa'
union all select 'ÖÐSQL'
union all select 'SQLÖÐ'
union all select 'aSQLa'
union all select 'ÖÐSQLÖÐ'
union all select 'SQaL'
union all select 'SQÖÐL'
union all select 'aSQaLa'
union all select 'ÖÐSQÖÐLÖÐ'
union all select 'Öйú_CN'
union all select 'a%ddd%b'
union all select '[]'
union all select '[[]'
union all select '[]]'
union all select '[[]]'
union all select '^-]'
union all select 'a^-]a'
È»ºó£¬ÎÒÃǽøÐÐÖð¸ö·ÖÎö
1¡¢ÎÒÃÇÖªµÀ£¬¶ÔÓÚ×Ö·û´®£¬Æ俪ʼºÍ½áÊø±êʶ·ûΪµ¥ÒýºÅ£¬Èç¹û×Ö·û´®ÀïÃæÓе¥ÒýºÅ£¬ÎÒÃÇ¿ÉÒÔÖ±½ÓʹÓÃÁ½¸öµ¥ÒýºÅÀ´Ìæ´ú¡£
ÐÎÈ磺¿Õ´® '', µ¥ÒýºÅ '''', ×Ö·û´® 'abAB#Öйú×Ö·û´®', °üº¬µ¥ÒýºÅµÄ´® 'abAB#Öйú''×Ö·û´®'.
2¡¢'_' ¡¢ '%'ºÍ'['
(1) '_'Æ¥Åäµ¥¸ö×Ö·û£¬Àý:
select * from EscapePattern where value like '_SQL' --²éÕÒËĸö×Ö·û£¬²¢ÇÒÒÔ'SQL'½áÊøµÄ¼Ç¼
½á¹ûΪ£ºaSQL ÖÐSQL
ÆäÖÐlikeÓï¾ä»¹¿ÉÒÔÕâÑùд£º
'SQL_' ²éÕÒËĸö×Ö·û£¬²¢ÇÒÒÔ'SQL'¿ªÊ¼µÄ¼Ç¼£¬½á¹û£ºSQLa SQLÖÐ
'SQ_L' ²éÕÒËĸö×Ö·û£¬²¢ÇÒÒÔ'SQ'¿ªÊ¼£¬ÒÔ'L'½áÊøµÄ¼Ç¼£¬½á¹û£ºSQaL SQÖÐL
'_SQL_' ²éÕÒÎå¸ö×Ö·û£¬ÖмäµÄÈý¸ö×
Ïà¹ØÎĵµ£º
ORDER BY ×Ӿ䰴һÁлò¶àÁУ¨×î¶à 8,060 ¸ö×Ö½Ú£©¶Ô²éѯ½á¹û½øÐÐÅÅÐò¡£ÓÐ¹Ø ORDER BY ×Ó¾ä×î´ó´óСµÄÏêϸÐÅÏ¢£¬Çë²ÎÔÄ ORDER BY ×Ó¾ä (Transact-SQL)¡£
Microsoft SQL Server 2005 ÔÊÐíÔÚ from ×Ó¾äÖÐÖ¸¶¨¶Ô SELECT ÁбíÖÐδָ¶¨µÄ±íÖеÄÁнøÐÐÅÅÐò¡£ORDE ......
ÔÚSQL ServerµÄÐÔÄܵ÷ÓÅÖУ¬ÓÐÒ»¸ö²»¿É±ÈÄâµÄÎÊÌ⣺ÄǾÍÊÇÈçºÎÔÚÒ»¶ÎÐèÒª³¤Ê±¼äµÄ´úÂë»ò±»Æµ·±µ÷ÓõĴúÂëÖд¦ÀíÁÙʱÊý¾Ý¼¯?±í±äÁ¿ºÍÁÙʱ±íÊÇÁ½ÖÖÑ¡Ôñ¡£
¡¡¡¡ÔÚSQL ServerµÄÐÔÄܵ÷ÓÅÖУ¬ÓÐÒ»¸ö²»¿É±ÈÄâµÄÎÊÌ⣺ÄǾÍÊÇÈçºÎÔÚÒ»¶ÎÐèÒª³¤Ê±¼äµÄ´úÂë»ò±»Æµ·±µ÷ÓõĴúÂëÖд¦ÀíÁÙʱÊý¾Ý¼¯?±í±äÁ¿ºÍÁÙʱ±íÊÇÁ½ÖÖÑ¡Ôñ¡£¼ÇµÃÔÚ¸øÒ»¼Ò ......
XËø¼´ÊÇÎÒÃdz£ËµµÄÅÅËüËø£¬UËøºÜÉÙ¼û£¬Ö»ÔÚ¸üÐÂʱ»á³öÏÖ¡£UËøÆäʵÊÇXËøµÄÒ»ÖÖ£¬µ±Êý¾Ý¸üÐÂʱ£¬UËøÊ×Ïȼӵ½Òª¸üеÄÊý¾ÝÉÏ(¼´Ê¹Ä¿±êÉÏÃæÓÐSËø£¬UËø»¹ÊÇ¿ÉÒÔ¼ÓÉÏ)£¬µÈÄ¿±ê¿ÉÒÔ±»¸üÐÂʱ£¬UËø¼´×ª±äΪXËø¡£ ÈçÐèתÔØ£¬Çë×¢Ã÷±¾ÎÄÔ´´×ÔCSDN TJVictorרÀ¸£ºhttp://blog.csdn.net/tjvictor ......
ÎÒÃÇÒª×öµ½²»µ«»áдSQL£¬»¹Òª×öµ½Ð´³öÐÔÄÜÓÅÁ¼µÄSQLÓï¾ä¡£
£¨1£©Ñ¡Ôñ×îÓÐЧÂʵıíÃû˳Ðò(Ö»ÔÚ»ùÓÚ¹æÔòµÄÓÅ»¯Æ÷ÖÐÓÐЧ)£º
OracleµÄ½âÎöÆ÷°´ÕÕ´ÓÓÒµ½×óµÄ˳Ðò´¦Àífrom×Ó¾äÖеıíÃû£¬from×Ó¾äÖÐдÔÚ×îºóµÄ±í(»ù´¡±í driving
table)½«±»×îÏÈ´¦Àí£¬ÔÚfrom×Ó¾äÖаüº¬¶à¸ö±íµÄÇé¿öÏÂ,Äã±ØÐëÑ¡Ôñ¼Ç¼ÌõÊý×îÉٵıí×÷Ϊ»ù´¡±í¡£È ......