quot;Ignatius Reilly" <[EMAIL PROTECTED]>
28/08/2003 11:29
To: <[EMAIL PROTECTED]>
cc: <[EMAIL PROTECTED]>
Subject:Re: [PHP-DB] Simple field replace...?
Then a simple substring will do:
UPDATE mytable
SET url = SUBSTRING( url FROM 5
ECTED]
Sent: 28 August 2003 11:07
To: Ignatius Reilly
Cc: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] Simple field replace...?
Sorry, I'll specify...
I have one column, in a row of perhaps 4 fields.
I want to remove the first 32 characters from onlt one field
EG:
My DB:
namedateurl ip
t;[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 12:06 PM
Subject: Re: [PHP-DB] Simple field replace...?
> Sorry, I'll specify...
> I have one column, in a row of perhaps 4 fields.
> I want to remove the first 32 characters from onlt one field
>
> EG:
> My DB:
>
> nam
TED]>
cc:
Subject:Re: [PHP-DB] Simple field replace...?
hundreds of what? rows or columns?
Ignatius
_
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 11:35 AM
Subject:
Try using the substring function in your sql statement
Substring('String',32);
Jack
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, August 28, 2003 11:35 AM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Simple field replace...?
Hi there,
I need to tak
hundreds of what? rows or columns?
Ignatius
_
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 28, 2003 11:35 AM
Subject: [PHP-DB] Simple field replace...?
> Hi there,
> I need to take a field in my database, and remove
I guess there is no other solution
just do it one at a time... it's no problem even if there are 100's.
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: donderdag 28 augustus 2003 11:35
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Simple field replace...?
Hi the