Mysql fuzzy search

Anon

Forgive me for being slightly off-topic, but I thought that all you wiz out there could easily help me with this one.

I'm doing a search in a mysql database where I compare words, like this:
SELECT .... FROM .... WHERE word IN ('word1', 'word2', ...)

It all works like a charm, but I would like to expand the search to be 'fuzzy'. So that if word='matchbox' and word1='match' would generate a hit.

Regards
P Degerman, SWEDEN

Anon

Make the select like this

SELECT .... FROM .... WHERE word IN ('%word1%', '%word2%', ....)

the % simply means any any char (not limited to only one)...

Andreas Bernharsen
Graficonn

Anon

You may also want to look into the soundex functions in mysql...
It probably woudn't work in your example, but find "Merry" if you were looking for "Mary"

SOUNDEX(str)
Returns a soundex string from str. Two strings that sound about the same'' should have identical soundex strings. Astandard'' soundex string is 4 characters long, but the SOUNDEX() function returns an arbitrarily long string. You can use SUBSTRING() on the result to get a ``standard'' soundex string. All non-alphanumeric characters are ignored in the given string. All international alpha characters outside the A-Z range are treated as vowels.
mysql> select SOUNDEX('Hello');
-> 'H400'
mysql> select SOUNDEX('Quadratically');
-> 'Q36324'

Anon

<-- snip,snip -->
SELECT .... FROM .... WHERE word IN ('%word1%', '%word2%', ....)
<-- snip,snip -->

I don't think that will work, ths %-wildcards only work together with LIKE, not IN...

Anon

what is actually % mean ? please tell me detail.

i'm a newbie in php

thanks