|
Posted by bobzimuta on 01/12/06 03:24
Also check out soundex() in mysql documentation.
In a query : SELECT first_name FROM people WHERE soundex( first_name )
= soundex( 'mark' )
will return something like the following
marcus
marko
.... (more)
Don't forget your 'like' queries as well...
SELECT first_name FROM people WHERE first_name LIKE 'mar%'
will return everything starting with 'mar'
You can also wrap strings for LIKE using '%string%' and '%string'
If you're interested in performance, text searching does take a bit of
computing power, so take that into consideration.
Navigation:
[Reply to this message]
|