¡¡¡¡SQLÎå¸ö¼¯ºÏº¯Êý£ºSUM,AVG,COUNT,MAX,MIN
¡¡¡¡Í¨Åä·ûµÄһЩÓ÷¨£º(¹Ø¼ü×Ö£ºlike % [] -) ¡¡¡¡select * from tablename where column1 like '[A-M]%' ¡¡¡¡ÕâÑù¿ÉÒÔÑ¡Ôñ³öcolumn×Ö¶ÎÖÐÊ××ÖĸÔÚA-MÖ®¼äµÄ¼Ç¼ ¡¡¡¡select * from tablename where column1 like '[ABC]%' ¡¡¡¡ÕâÑù¿ÉÒÔÑ¡Ôñ³öcolumn×Ö¶ÎÖÐÊ××ÖĸÊÇA»òÕßB»òÕßCµÄ¼Ç¼ ¡¡¡¡select * from tablename where column1 like '[A-CG]%' ¡¡¡¡ÕâÑù¿ÉÒÔÑ¡Ôñ³öcolumn×Ö¶ÎÖÐÊ××ÖĸÔÚA-CÖ®¼äµÄ»òÕßÊÇGµÄ¼Ç¼ ¡¡¡¡select * from tablename where column1 like '[^C]%' ¡¡¡¡ÕâÑù¿ÉÒÔÑ¡Ôñ³öcolumn×Ö¶ÎÖÐÊ××Öĸ²»ÊÇCµÄ¼Ç¼
¡¡¡¡ÍÑ×Ö·û£¨¹Ø¼ü×Ö£ºlike _£© ¡¡¡¡Í¨¹ýʹÓÃÏ»¬Ïß×Ö·û£¨_£©£¬¿ÉÒÔÆ¥ÅäÈÎÒâµ¥¸ö×Ö·û ¡¡¡¡select * from tablename where column1 like 'M_crosoft'
¡¡¡¡Æ¥ÅäÌØÊâ×Ö·û£º£¨[ ] _ - %£© ¡¡¡¡°ÑËûÃǶ¼·Åµ½[]ÖоÍÐÐÁË£¬±ÈÈ磺 ¡¡¡¡select * from tablename where column1 like '%[%]%'
¡¡¡¡Æ¥Åä·¢Òô£¨¹Ø¼ü×Ö£ºSOUNDEX DIFFERENCE£© ¡¡¡¡Èç¹û²»ÖªµÀÒ»¸öÃû×ÖÈ·Çеķ¢Òô£¬µ«ÊÇÓÖ¶àÉÙÖªµÀÒ»µã£¬¿ÉÒÔ¿¼ÂÇʹÓÃSOUNDEX DIFFERENCEº¯Êý¡£ ¡¡¡¡select * from tablename where DIFFERENCE(column1,'Laofei'>3) ¡¡¡¡DIFFERENCE·µ»Ø0-4Ö®¼äµÄÊý×Ö£¬4ÊǷdz£½Ó½ü£¬0ÊDzîÒì·Ç³£´ó ¡¡¡¡ÒªÉîÈëÁ˽âDIFFERENCEº¯ÊýµÄ¹¤×÷ÔÀí£¬Ê¹ÓÃSOUNDEXº¯Êý·µ»ØDIFFERENCEº¯ÊýËùʹÓõÄÒô±êÂë ¡¡¡¡select column1 as column,SOUNDEX(column1) 'sound like'
¡¡¡¡×¢Ò⣺ ¡¡¡¡DIFFERENCEº¯Êý±È½ÏÁ½¸ö×Ö·û´®µÄµÚÒ»¸ö×ÖĸºÍËùÓеĸ¨Òô×Öĸ£¬¸Ãº¯ÊýºöÂÔÈκÎÔªÒô×Öĸ£¨°üÀ¨Y£©,³ý·ÇÔªÒô×ÖĸÊǸÃ×Ö·û´®µÄµÚÒ»¸ö×Öĸ¡£ ¡¡¡¡Ê¹ÓÃÕâÁ½¸öº¯ÊýÔÚwhereÖÐÖ´ÐÐЧ¹û²¢²»ºÃ£¬ËùÒÔ¾¡Á¿ÉÙʹÓᣠ|