mysql Full-Text Search syntax

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 […]