Worked like a dream Dan
Thanks Paul for being patient :)
Thank you
Andrew
>-Original Message-
>From: Dan Greene [mailto:[EMAIL PROTECTED]
>Sent: 17 November 2003 21:27
>To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista
>Subject: RE: replace query + RTFM?
>
>
>you
On Monday 17 November 2003 01:18 pm, Andrew wrote:
> Can someone kindly tell me what I doing wrong and help with this query?
>
> I want to replace / update the text for every record within table items
> field ItemDescription. This is what I have so far and its isn't corroect :(
>
> UPDATE items SET
[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 4:19 PM
> To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista
> Subject: RE: replace query + RTFM?
>
>
>
>
> Can someone kindly tell me what I doing wrong and help with
> this query?
>
> I want to replace / update the te
Can someone kindly tell me what I doing wrong and help with this query?
I want to replace / update the text for every record within table items field
ItemDescription. This is what I have so far and its isn't corroect :(
UPDATE items SET ItemDescription='A-Z Business Directory Please
call 0870
>Looks to me like you want to use UPDATE instead. Specify a WHERE clause
>that identifies the rows you want to update, and in the SET clause specify
>the new value for the description column.
>
>To pre-flight your UPDATE, you can write a SELECT that has the same WHERE
>clause. This will show you
3 18:31
To: [EMAIL PROTECTED]; MySQL-Lista; Rodolphe Toots
Subject: RE: replace query + RTFM?
Andrew,
Please allow a small amount of grief to come from these lists...
People are usually glad to help, and Mike sent the info that he knew
to you. There is a certain amount of frustration that develops w
ta; Rodolphe Toots
>Subject: RE: replace query + RTFM?
>
>
>Andrew,
>
>Please allow a small amount of grief to come from these lists...
>People are usually glad to help, and Mike sent the info that he knew
>to you. There is a certain amount of frustration that develops when
>
box]
Dan Greene
> -Original Message-
> From: Andrew [mailto:[EMAIL PROTECTED]
> Sent: Monday, November 17, 2003 1:16 PM
> To: MySQL-Lista; Rodolphe Toots
> Subject: RE: replace query + RTFM?
>
>
> amazing, and you guys are errr intelligent!!! can't actually
&g
[EMAIL PROTECTED]
>Subject: SV: replace query + RTFM?
>
>
>RTFM = "read the fucking manual"..
>
>-Ursprungligt meddelande-
>Från: Andrew [mailto:[EMAIL PROTECTED]
>Skickat: den 17 november 2003 18:55
>Till: Mikael Fridh; [EMAIL PROTECTED]; MySQL-Lista
>
Hi Mike
I really appreciate you getting back to me so quickly :)
Can I just clarify this becuse I have over 4000 records and not all of the
records have anything in items - description but there are about 2500 records
with this exact text->
A-Z Business Directory Please call 0116 27 960 41 for
10 matches
Mail list logo
