searching...

[Destramic]

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

 

[phpPeter]

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%'