Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%

pl/SqlÈçºÎ²éѯ×Ö·û´®°üÀ¨%, 
ÀýÈç:TABLE a
columnA
'222'
'33%44'

ÈçºÎ²éѯ±íaÖÐcolumnA×Ö¶ÎÖÐÄÄЩÐаüº¬'%'

лл
select * from a
where columna like '%/%%' escape '/'

UP

SELECT * from a WHERE columnA LIKE '%\%%' ESCAPE'\';

ÆäÖУ¬ESCAPE'\'±íʾ£º\Ϊ»»Âë×Ö·û£¬Æ¥Åä´®ÖиúÔÚ\ºóÃæµÄ×Ö·û%²»ÔÙ¾ßÓÐͨÅä·ûµÄº¬Ò壻
תÒåΪÆÕͨµÄ¡°%¡±×Ö·û¡£


ÒýÓÃ
select * from a
where columna like '%/%%' escape '/'

UP


Â¥Éϵķ½·¨¹ÜÓ㬵«ÊÇżÏëÎÊÒ»¸öÈç¹û×Ö·û´®Àï°üº¬ÓÐ'£¨µ¥ÒýºÅ£©µÄÒªÔõôÓÃLike²éѯ°¡£¿£¿

select * from t1 where instr(f1,'%') != 0 ;

ÓÃÕýÔò±í´ïʽ°É£º
select * from dual
where 'tian%dd'like '%/%%' escape '/';

ÒýÓÃ
Â¥Éϵķ½·¨¹ÜÓ㬵«ÊÇżÏëÎÊÒ»¸öÈç¹û×Ö·û´®Àï°üº¬ÓÐ'£¨µ¥ÒýºÅ£©µÄÒªÔõôÓÃLike²éѯ°¡£¿£¿


select * from t1 where instr(f1,'''') != 0;

ÒýÓÃ
Â¥Éϵķ½·¨¹ÜÓ㬵«ÊÇżÏëÎÊÒ»¸öÈç¹û×Ö·û´®Àï°üº¬ÓÐ'£¨µ¥ÒýºÅ£©µÄÒªÔõôÓÃLike²éѯ°¡£¿£¿

where col1 like '%''%'
»ò
where col1 like '%'||chr(39)||'%'
»ò
where instr(col1,chr(39))>0


Â¥Ö÷ÓÃOracle ÕýÔòÊÔÊÔ
SQL code:

with tt as (
select '33%44''' COL from dual
)

select * from


Ïà¹ØÎÊ´ð£º

access ÖÐÖ´ÐÐsqlÓï¾äupdate²»³É¹¦£¬ÇóÖú£¡£¡£¡

access ÖÐÖ´ÐÐsql updateÓï¾äʱÓÐʱºò³É¹¦ÓÐʱºò²»³É¹¦£¬µ«ÊÇaccessÖв»³ö´íÎóÐÅÏ¢£¬²»ÖªµÀÊÇʲôԭÒò£¬ÓÐÄÄλ´óÏÀÖªµÀ£¬Çë°ïæ°¡
ÌùSQLÓï¾ä£¬¼ì²é±í¡¢×ֶεÄÓÐЧÐÔÉèÖÃ

sql ÔÚ²éѯ·ÖÎöÆ÷ÀïÃæ Ö´ÐкÜÕý³£

ÊÇ ......

sqlÓï¾ä¶à±í¶à×ֶβéѯ - MS-SQL Server / »ù´¡Àà

ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд 

ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......

¹ØÓÚDelphiʹÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿âµÄÎÊÌâ

СµÜÎÒÓÃADOÁ¬½ÓSQL server 2000Êý¾Ý¿â£¬È»ºóÔÚDBGridÖÐÏÔʾ£¬ÏÖÔÚÏë°ÑÔÚDBGridÖвéѯµ½µÄÊý¾ÝiPlot×÷ͼ£¬ÇëÎÊÈçºÎʵÏÖÔÚDBGridÖеÄÊý¾Ý¶ÁÈ¡£¬¶Á³öµÄÊý¾ÝÊÇSTRINGÀàÐ͵ģ¬ÈçºÎÓÐЧµÄת±ä³ÉÊý¾Ý¿âÖÐËù´æ´¢µÄDOUBLEÀàÐ ......

ÇóÒ»¸ösqlÓï¾ä

A±í          B±í
WZID WZJG    WZID  CKID WZSL
ÏÖÔÚÒª²é¶ÔÓ¦µÄÿһ¸öCKIDϵÄ×ܵĽð¶î
¾ÍÊÇÏȲéÿ¸öWUIDÔÚB±íÀïµÄÊýÁ¿£¬È»ºóÓÃWZJG*sum(wzsl)£¬È»ºóÔÙ°´ÕÕÿ¸ ......

ÇóÒ»¸öSQLÃüÁî

ÓÐÒ»Õűí(SHGL)
JLBH        LXR              LXDH            SHDZ
1            a ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ