[RESOLVED] FULLTEXT Searching question

[seanl]

I am using a MATCH on a fields in a mysql database to provide users with a search function as below

$query_rsContent = sprintf("SELECT * FROM table WHERE MATCH (title,body) AGAINST ('.$find.' IN BOOLEAN MODE) ");

$find is the post variable from a form

The search works OK, but lets me down in one respect

If I search for 'cyber', I get hits, if I search for 'cyb' I get nothing.

How can I search with a bit more flexibility?

Thanks,

Sean.

[dagon]

add a * or two

$query_rsContent = sprintf("SELECT * FROM table WHERE MATCH (title,body) AGAINST ('$find*' IN BOOLEAN MODE) ");

or maybe

$query_rsContent = sprintf("SELECT * FROM table WHERE MATCH (title,body) AGAINST ('*$find*' IN BOOLEAN MODE) ");

11.8.2. Boolean Full-Text Searches

[seanl]

Thanks, that did it.

And thanks to whoever moved it to the appropriate list.