Categories
DATABASE

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

Categories
DATABASE Programming/misc Programming/php Software System/Linux/Unix*

Protected: Senna for mysql install 安裝說明

There is no excerpt because this is a protected post.