|
Posted by SqlDope on 01/08/07 22:44
Hello, I wonder if anyone can help me
My Table
ID Sunames Inscription
typical entrys
ID 10
Surnames @ABBOTT@JONES@
rem the @ is there so that I can select a whole word and not get ABBOT
Inscription John ABBOTT died 10 june 1857 also his sister mary JONES died 16
may 1868
my query
if ($soundex==exact)
$query="Select * FROM paupers WHERE surnames LIKE '%@$name@%'"
else
$query="Select * FROM paupers WHERE soundex(surnames) LIKE
'%@(soundex($name))@%'"
the first part -- LIKE '%@$name@%' works fine
but I can`t get the syntax for the soundex bit right
any help appreciated
Regards
Navigation:
[Reply to this message]
|