|
|
Posted by bill on 03/18/07 18:50
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
Navigation:
[Reply to this message]
|