Phrase search in MySQL

Simes

Can anyone throw some light on this one. I would expect this search to result in records that include the exact phrase "party happiness". However, it seems to treat the search string as party OR happiness.

$bool = "\"party happiness\"";

$sql = "SELECT *,
	MATCH(record_title, record_text)
	AGAINST('$bool' IN BOOLEAN MODE) AS score
	FROM record, artist
	WHERE MATCH(record_title, record_text)
	AGAINST('$bool' IN BOOLEAN MODE)
	&& record.artist_id = artist.artist_id
	ORDER BY record_title

Any ideas anyone.

Thanks,
Simon

nemonoman

You're doing a 'FULLTEXT' search which likes to find near-misses

I'd do this:

SELECT * from record WHERE record_title LIKE '%party happiness%' OR record_text LIKE '%party happiness%'

Which WILL give you exact phrase

Simes

Thanks nemonoman,

This seems to work but is it possible to get this to work correctly with more a complicated search phrases such as:

"jonathan richman" +party
"jonathan richman" -lovers

Also, is this a bug in FULLTEXT or am I just misunderstanding the manual at http://www.mysql.com/doc/en/Fulltext_Search.html

Thanks,
Simon