You are here: Re: Like and Soundex help please « PHP SQL « IT news, forums, messages
Re: Like and Soundex help please

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.

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация