|
|
Posted by Jerry Stuckle on 03/18/07 21:20
bill wrote:
> Thanks to a kind member of this group I was able to write a select that
> ignored "The " in a field:
> ORDER BY REPLACE(kennel_name,'The ','')
> and it works fine.
>
> I did check the mysql documentation site, but couldn't find this use of
> replace.
>
> What I want to do now is ignore "The " and "A " in a select, ie: replace
> both "The " and "A " with "".
>
> What would be the correct syntax ?
>
> bill
comp.database.mysql.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================
Navigation:
[Reply to this message]
|