mysqlÔõôʵÏÖÄ£ºý²éѯº¬%µÄÊý¾Ý
µÃÓÃlike
ÊÇmysql
SELECT * from TB WHERE COL LIKE '%AFDA%'
mysql?
SQL code:
²»¶®£¬°ï¶¥£¬Ñ§Ï°£¬²ä·Ö.
ÕûÀíһϠ¥Ö÷µÄÒâ˼¡£
ÊÇÓà mysql ʵÏÖ ²éѯ Êý¾ÝÖк¬ÓÐ % µÄÊý¾Ý£¡
ÊÇÓà mysql ÖеÄlikeÓï¾ä ʵÏÖ ²éѯ Êý¾ÝÖк¬ÓÐ % µÄÊý¾Ý£¡
SQL code:
select * from student where sname like '%[%]%'
msserverÖÐÓÃ like '%[%]%'
ÔÚmysql²»ÐУ¬»áµÄ¸æËß°³ лл£¡
sorry..
°ï¶¥
SQL code:
SELECT * from TB '%''%''%'
ÖªµÀÁË ÊÇ like '%\%%'
Ïà¹ØÎÊ´ð£º
Õâ¸öÊÓÆµ½²µÄºÜÏêϸ, ¶ÔÐÂÊַdz£ÓÐÓÃ, »ù±¾ÉÏÒ»¿´¾Í¶®
ÓÉÓÚÌ«´óÁË(50m, ÎÒÖ»ÄÜÉÏ´«20m), ÎÒÉÏ´«²»ÁË, Ö»ºÃÌù³öÏÂÔØµØÖ·
ÏÂÔØµØÖ·: http://ftel1.3800hk.com/0807/080720djxnzj.rar
ºÃ¶«Î÷,ϸö¿´¿´
......
ÎÒ¿ª·¢ASP.netʱ
²åÈëÍâÎÄÂÒÂë
SHOW VARIABLES LIKE 'character%';
Õâ¸öʱºò
character_set_client utf8
character_set_connection utf8
character_set_database utf8
ch ......
ÎÒµÄmysqlÔõôûÓа취дÈëÖÐÎÄÊý¾Ý£¿Ö»ÒªÊÇÊý¾ÝдÈëÊý¾Ý¿âʱ ¾Í»á±ä³ÉÈý¸öÎʺŠ£¿Çë½Ì¸ßÈË£¡£¡
linux? ÔõôдÈëµÄ
ÔÚmysqlÖÐÖ´ÐÐ show variables like 'character%'Ìù½á¹û³öÀ´¡£
ÔÚ°²×°MYSLQʱ½«Êý¾Ý¿âµÄ×Ö· ......
¸Õ°²×°mysqlµÄʱºò£¬°Ñ³õʼÃÜÂëÍü¼ÇÁË£¬Ö»ºÃÌø¹ýȨÏÞÑéÖ¤£¬ÐÞ¸ÄÃÜÂ룬Ð޸ijɹ¦ºó£¬ÄܵǼ£¬¿ÉÊÇ»úÆ÷ÖØÆôÁË£¬ÓøĹýµÄÃÜÂëÓֵDz»ÉÏÁË£¬ÏÂÎÄÊÇÐ޸ĵķ½·¨£¬²»ÖªµÀÄÄÀï³öÁËÎÊÌ⣿
ÃÜÂëÐ޸ķ½·¨£º
1.ÒÔϵͳ¹ ......
ÎÒ°²×°µÄÕâ¸öÈí¼þVertrigoServ£¬ÔÚwindows7ÖÐÔËÐУ¬Í¼±ê¼ÓºÅΪÀ¶É«£¬±¨MySQLµÄ´íÎó£¬Çë½Ì¸÷λ¸ßÊÖ¸ÃÔõÑù¸ü¸Ä¡£Ð»Ð»¸÷λ£¡
mysql ·þÎñÊÇ·ñÆðÀ´ÁË£¿
ûÓУ¬±¨µÄÊǶ˿ڴíÎó£¬ÔÚÅäÖÃÎļþµ±ÖиÄÁË£¬Ò²²»ÐÐ
¿ÉÒÔÓÃÈ ......