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
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 the
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
-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: [PHP-DB] Simple field replace...?
Hi there,
I need to take a field
, 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:
namedateurl ip
bob 1/2/99 http:// 1.1.1.1.
sue 4/6/01
:[EMAIL PROTECTED]
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
[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 )
btw your date column looks pretty awful.
HTH