John Sidney-Woollett wrote:
I need to locate all the entries in a table that match , but only
after a number of characters have been ignored. I have a table of
email addresses, and someone else has erroneously entered some
addresses prefixed with 'mailto:', which I'd like to ignore.
>
Or something like
select ltrim(substr(address, 8)) from people where address like
'mailto:%' union select address from people where address not like
'mailto:%'
Could you explain why the UNION?
brian
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
