o9s
is a microblog
home archives search feed blogroll


SOUNDEX

SOUNDEX is one of those cool SQL function that is implemented in most database management systems.

SELECT *
FROM people
WHERE SOUNDEX(first_name) = SOUNDEX('Henri')

It picks up Henri, Henry and weirdly Henru.

SELECT *
FROM people
WHERE SOUNDEX(first_name) = SOUNDEX('Simon')

It picks up Simon, Sam, Suzanne, Sue, Susan, Suzanna, etc. It obviously picks up too much in this case.

SELECT *
FROM people
WHERE SOUNDEX(first_name) = SOUNDEX('Robert')

It does not do nicknames. This does not pick up Bob.

My girlfriend works in a call center. On the system she uses there is a form to search for a client. On this form there is a Name:” field. There is also a Name sounds like:” field. She uses the latter when it’s getting too awkward to ask a client for his name for the tenth time because she can’t understand the person. I’m confident that the programmers used the SOUNDEX function.

Posted on 2018-02-27   #sql     #database     #til  






← Next post    ·    Previous post →