FULLTEXT Problem

[Anon]

Okay, so I have a table called urls, with url_id, url_title, and url fields...

i created a fulltext index on teh url_title field, as I want to perform a search on this...

I use the following SQL statement

SELECT * FROM urls WHERE MATCH (url_title) AGAINST ('$search_string');

it returns no results, if $search_string = 'outlook', yet outlook is in contained within one of the url_title rows...

am i doing something wrong?

[Anon]

Why not do it like this ?

SELECT * FROM urls WHERE url_title like '%$search_string%';

[Anon]

because that won't work with mutliple words...i actually want to use

SELECT * FROM links WHERE MATCH (link_title) AGAINST ('$search_string' IN BOOLEAN MODE)

so that way i could say maybe +outlook +africa

or something like that

[Anon]

How about exploding your searchwords into individual words and adding an OR statement for each word to your query? Probably not how you want to do it, but it will work.

[Anon]

yeah i tried this but for some reason it still doesn't search on the last word..

example

(after exploding)
SELECT link_title,url FROM links WHERE link_title LIKE '%test%' OR '%climate%';

this produces no results

however
SELECT link_title,url FROM links WHERE link_title LIKE '%climate%' OR '%test%';

produces 3 results....?

[Anon]

Change it to create your query like this

SELECT link_title,url FROM links WHERE link_title LIKE '%climate%' OR link_title LIKE '%test%'