Page 1 of 1

Multiple column->value searches

Posted: Mon Jul 24, 2006 8:03 pm
by LiveFree
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

Posted: Mon Jul 24, 2006 8:15 pm
by feyd
nope.

Posted: Mon Jul 24, 2006 8:17 pm
by LiveFree
Damn,

Ok then is there a way to effeciantly co-allesse the results from the searches so I get a good search result?

Like combining the results from these:

SELECT title FROM music WHERE MATCH(title) AGAINST ($title)
SELECT genre FROM music WHERE MATCH(genre) AGINST ($genre)
x2

Thanks feyd

Posted: Mon Jul 24, 2006 8:19 pm
by feyd
hint: match() .. and match() .. and match() ..

Posted: Mon Jul 24, 2006 8:28 pm
by LiveFree
You can use more than 1? Awsome!