Destramic Posted July 26, 2014 Share Posted July 26, 2014 I've been reading a few tutorials on how the best way to search key words in a database and at the moment im trying to get this query to work but its coming back with a error: #1191 - Can't find FULLTEXT index matching the column list query: SELECT title, description FROM items WHERE MATCH(title, description) AGAINST('xbox') any help or advise on how the best way to search 2 columns on matching words...thank you Quote Link to comment https://forums.phpfreaks.com/topic/290121-searching/ Share on other sites More sharing options...
phpPeter Posted August 5, 2014 Share Posted August 5, 2014 It seems, it is required to define fulltext indices on the relevant columns (ALTER TABLE items ADD FULLTEXT `TSTIDX` ( `title` )... I think, indices of type "FULLTEXT" are not available on all types of tables (MyISAM seems to be okay, but InnoDB not). I prefer the conservative way using "LIKE". Bit more effort to write the SQL, but will work with all types of databases: WHERE title LIKE '%xbox%' OR description LIKE '%xbox%' Quote Link to comment https://forums.phpfreaks.com/topic/290121-searching/#findComment-1486927 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.