Asterisk

[Yamakazi]

Hello,

I'm creating an intranet site and at the moment i'm developing a search function. I'm using the match against query's of mysql and they work fine. I can create percentage hits and all that stuff.
Now i found one minor thing about this way of using mysql.
If you do a search on *anssens the search function doesn't find a person called janssens. I found this command in de MySQL docs:

'An asterisk is the truncation operator. Unlike the other operators, it should be appended to the word, not prepended. '

Ok, i understand they didn't insert this functionallity but can i program this functionallity myself?

[leatherback]

Hi,

If you replace the * with % it should work.

so: Select * from table where colum like "%anssens"

J.

[Yamakazi]

Ok, i thought of that one myself but can anyone tell me the impact of such a query.

Time it will take

Match against <-> Select

TIA