Re: Querying for strings that match after prefix

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