Posted by Paul Lautman on 01/09/07 12:58

SqlDope wrote:
> 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

You should not put lots of surnames in a single record. Each surname should
occupy its own single field in a single record.

[Back to original message]