Advanced FULLTEXT Search

[Greg Young]

Hi all,

I have the following query to run a boolean query on various columns in my database placing weight on title before any other column...

----------------------

SELECT *, ( (1.3 * (MATCH(title) AGAINST ('wood' IN BOOLEAN MODE))) + (0.6 * (MATCH(isbnnospace,title,description1,description2,description3,description4,authorName) AGAINST ('wood' IN BOOLEAN MODE)))) AS relevance FROM tblBooks WHERE ( MATCH(isbnnospace,title,description1,description2,description3,description4,authorName) AGAINST ('wood' IN BOOLEAN MODE) ) and OP = 'FALSE' HAVING relevance > 0 ORDER BY relevance DESC

----------------------

This is currently working well and it's correctly returning rows with "wood" in the title before other columns, but I need to make a slight change to this.

There are various books in the database with the titles like "Woodturning" or "Woodwork Management". How can I modify the above query to include these books in the returned results?

Thanks very much in advance!