Delixe Posted March 30, 2007 Share Posted March 30, 2007 I found one way which is great with speeds: SELECT * FROM `fmc_archive_dev` WHERE (MATCH(itm_desc) AGAINST('Zune') OR MATCH(itm_desc) AGAINST('xss') OR MATCH(itm_desc) AGAINST('ajax') OR MATCH(itm_desc) AGAINST('rsnake') OR MATCH(itm_desc) AGAINST('virus') OR MATCH(itm_desc) AGAINST('porn') OR MATCH(itm_desc) AGAINST('final fantasy') OR MATCH(itm_desc) AGAINST('domain') OR MATCH(itm_desc) AGAINST('web 2.0') OR MATCH(itm_desc) AGAINST('web development') OR MATCH(itm_desc) AGAINST('steve nash') OR MATCH(itm_desc) AGAINST('reverse engineering')) AND archived_on > 1175150209 How do you add multiple columns to the MATCHES? Is there a way to optimize this more? Link to comment https://forums.phpfreaks.com/topic/44898-mysql-fulltext-optimization/ Share on other sites More sharing options...
fenway Posted April 4, 2007 Share Posted April 4, 2007 Well, you could make a multi-column fulltext index -- I think 16 columns is the max Link to comment https://forums.phpfreaks.com/topic/44898-mysql-fulltext-optimization/#findComment-221189 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.