«
»

mysql Full-Text Search syntax

2009/08/11, 12:32 pm

ef5dc3eace8cd26e67fb8eb3987eb729

mysql> explain
    -> select SQL_CALC_FOUND_ROWS tbl_item.g_no, tbl_item.ctrl_rowid ,tbl_item.rank , g_priority_order
    -> from tbl_item
    -> where
    -> match(g_name_key) against('+AA +BB CC' in boolean mode)
    -> and tbl_item.g_end_int > 1249953400
    -> and tbl_item.g_class not like '0025%'
    -> order by g_priority_order desc, tbl_item.rank desc,tbl_item.g_post_time desc limit 0, 30\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: tbl_item
         type: fulltext
possible_keys: ndx_g_end_int,ndx_g_name_key
          key: ndx_g_name_key
      key_len: 0
          ref:
         rows: 1
        Extra: Using where; Using filesort
1 row in set (0.00 sec)
Tags: , ,
Category: DATABASE

Comments are closed.

Related URL:
  1. Protected: [LAB] Best practices guidelines for running MySQL databases on NetApp® storage , 測試結果
  2. amazon aws ami LAMP / NGINX / PHP / memcache steps
  3. 建 mysql partition table 遇到的問題
  4. Protected: [memo] mysql CPU / MEMORY / DISK / SERVER
  5. [memo] MySQL PROCEDURE ANALYSE / schema 分析
  6. Protected: dbs222 mysql innodb Troubleshutting
  7. mysql performance tunning – pdf
  8. 使用 mysql partition table sample
  9. Protected: mysql myisam performance tunning 過程 – sample data
  10. Protected: mysql innodb 的部份參數 , my.cnf