# [EMAIL PROTECTED] / 2006-06-02 05:18:08 -0700:
> I think I need to explain a bit further.
>
> I tried simply using
>
> update people
> replace(address, 'mailto:','');
>
> but unfortunately that produced a duplicate key error as some of the
> addresses prefixed with 'mailto:' are already presen
Hi there,
I think I need to explain a bit further.
I tried simply using
update people
replace(address, 'mailto:','');
but unfortunately that produced a duplicate key error as some of the
addresses prefixed with 'mailto:' are already present (unprefixed) in
the table.
So what I need to do is fi
badlydrawnbhoy <[EMAIL PROTECTED]> wrote:
> I hope this is the right forum for this, but please correct me if
> somewhere else is more appropriate.
>
> 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
> ad
John Sidney-Woollett wrote:
brian ally wrote:
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
1) select ltrim(substr(address, 8)) from people
where address like 'mailto:%'
gives all addresses that start with "mailto:"; but first strips off the
prefix leaving only the email address
2) select address from people where address not like 'mailto:%'
produces all email address that don't nee
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 someth
Or something like
select ltrim(substr(address, 8)) from people
where address like 'mailto:%'
union
select address from people
where address not like 'mailto:%'
John
John Sidney-Woollett wrote:
Do you mean?
select replace(address, 'mailto:', '') from people
... and if you only want to find th
Do you mean?
select replace(address, 'mailto:', '') from people
... and if you only want to find the ones that start with "mailto:";
select replace(address, 'mailto:', '') from people
where address like 'mailto:%'
John
badlydrawnbhoy wrote:
Hi all,
I hope this is the right forum for this, b
On Fri, Jun 02, 2006 at 02:47:22AM -0700, badlydrawnbhoy 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:
Hi all,
I hope this is the right forum for this, but please correct me if
somewhere else is more appropriate.
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 enter
10 matches
Mail list logo
