Multiple column->value searches
Posted: Mon Jul 24, 2006 8:03 pm
Hello,
Is there a way to search more than 1 column with 1 search text in a FULLTEXT column?
For example is there a proper way of doing the equivilant of this:
SELECT * FROM music WHERE MATCH(id, title, genre) AGAINST(1, 'hahah', 'Rock')
Thanks
Is there a way to search more than 1 column with 1 search text in a FULLTEXT column?
For example is there a proper way of doing the equivilant of this:
SELECT * FROM music WHERE MATCH(id, title, genre) AGAINST(1, 'hahah', 'Rock')
Thanks