I am building a search feature with Cold Fusion and need to have similar
string matches included in the search results. I have a search form field
called hsname. I am trying to use the SOUNDEX function in my query like
this:
SELECT *
FROM accounts
WHERE SOUNDEX(hsname) = SOUNDEX('#form.hsname#')
If I enter Eisen into the search field, it should return one record if
SOUNDEX is working right. However, it doesn't return any records. If I hard
code Eisen into the search query like this (instead of the variable):
WHERE SOUNDEX(hsname) = SOUNDEX('Eisen')
SOUNDEX works as it should. Is there a problem with my SQL syntax? Or does
it not work with variables?
Thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
