SELECT a.*, MATCH(keyword)against('lady's trousers, ladies' trousers, women's trouser') as score 
		 FROM bb_product_keyword a left join bb_product b
		 on a.pro_id = b.pro_id
		 WHERE b.pro_state = 1 and b.pro_bbt_state <> 2 and MATCH (a.keyword) AGAINST ('lady's trousers, ladies' trousers, women's trouser') and a.com_id=1968 
		 group by a.keyword order by score desc limit 0,15You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's trousers, ladies' trousers, women's trouser') as score 
		 FROM bb_product_ke' at line 1