×÷Õߣºaolinks
Ò»¸öSELECT²éѯÖеÄLIKEÓï¾äÀ´Ö´ÐÐÕâÖÖ²éѯ£¬¾¡¹ÜÕâÖÖ·½·¨¿ÉÐУ¬
µ«¶ÔÓÚÈ«ÎIJéÕÒ¶øÑÔ£¬ÕâÊÇÒ»ÖÖЧÂʼ«¶ËµÍÏµķ½·¨£¬ÓÈÆäÔÚ´¦Àí´óÁ¿Êý¾ÝµÄʱºò¡£
-------------------
ÉÏÃæÕâ¾ä»° ÎÒÊÇÔÚÍøÉÏ¿´µ½µÄ£¬ ˵µÃͦÓеÀÀíµÄ£¬mysql ±¾ÉíÌṩÁËÒ»ÖÖ½Ð×öÈ«ÎÄËÑË÷µÄ¼¼Êõ°É£¬
²»¹ýÕâºÃÏñ´ÓºóÀ´µÄ°æ±¾²ÅÓеģ¬ ±È½Ï¾ÉµÄ°æ±¾²»Ö§³Ö£¬²»¹ýÄÇÊǺÜÔçÆÚµÄ°æ±¾ÁË£¬
ÏÖÔÚ´ó¼ÒʹÓõİ汾 Ó¦¸Ã¶¼Ö§³ÖµÄ¡£ÎÒÏÖÔÚʹÓÃmysql6.0.4 À´ÑÝʾ
È«ÎÄËÑË÷ ±ÈÆð Ë÷Òý ÎÒ¾õµÃ¸ü¼ÓÈ«Ãæ£¬ Ë÷ÒýÖ»¶Ôijһ¸ö×ֶΣ¬È»ºóÔÚ²éѯʱºòʹÓÃlike ÅäºÏ¡£
È«ÎÄËÑË÷Ëü¿ÉÒÔÉèÖöà¸ö×ֶνøÐÐËÑË÷£¬¿ÉÒÔ˵ÊÇ±ÈÆðselect .... like ¸ß¼¶°É¡£
ºÃÁË£¬ ¼ÈÈ» È«ÎÄËÑË÷ ÓÐÕâÑùµÄÓŵ㣬ÏÂÃæÎÒÃÇÀ´¿´¿´ ÊÇ·ñÕæµÄÈç´Ë¡£
ÏÂÃæÌṩµÄ²âÊÔÀý×Ó£¬ÊÇmysql ÊÖ²áÉÏÃæµÄÒ»¸öÀý×Ó
CREATE TABLE articles (
id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
title VARCHAR(200),
body TEXT,
FULLTEXT (title,body)
);
ÉÏÃæÕâÊÇ´´½¨±íµÄmysql Óï¾ä£¬ ÆäÖÐ×îºóÒ»¾ä FULLTEXT (title,body)
¾ÍÊÇΪtitle ºÍbody ´´½¨Ò»¸ö È«ÎÄËÑË÷£¬Ò²¾ÍÊÇ ÒÔºó ·½±ãËÑË÷ ±êÌâ ºÍ
±êÌâÕýÎĵÄÄÚÈÝ¡£¸´ÖÆÓï¾äÉÏÈ¥ ¾Í³É¹¦´´½¨Ò»ÕűíÁË¡£
²é¿´Ò»Ï ȫÎÄËÑË÷ ÊÇ·ñ±»´´½¨£¬ ÏÂÃæÓï¾ä×÷ÓÃÊÇ£º²é¿´±íµÄ Ö÷¼ü£¬ Ë÷Òý£¬ È«ÎÄËÑË÷
show indexes from ±íÃû
mysql> show indexes from articles;
+----------+------------+----------+--------------+-------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name |
+----------+------------+----------+--------------+-------------+
| articles | 0 | PRIMARY | 1 | id |
| articles | 1 | title | 1 | title |
| articles | 1 | title | 2 | body |
+----------+------------+----------+--------------+-------------+