Re: SELECT ... UPDATE

2004-03-12 Thread Victoria Reznichenko
"Darran Kartaschew" <[EMAIL PROTECTED]> wrote: > Hi Everyone, > > Is there an easy way to update a field for the last record referenced by > an ID number? where that ID number is used on multiple rows? > > At the moment I am doing this which works: > > CREATE TEMPORARY TABLE tmp_user ( SELECT u

RE: SELECT & UPDATE

2003-01-28 Thread Victor Pendleton
It may be possible since you used a MATCH ... AGAINST() search your hits were zero. Let me know if you do not understand my reply. -Original Message- From: Daniele Lo Re [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 28, 2003 8:24 AM To: [EMAIL PROTECTED] Subject: SELECT & UPDATE Hi e

RE: SELECT & UPDATE

2003-01-28 Thread Simon Green
Did the update work? I would expect it did and is just reported that you have not added or taken away any rows. Simon -Original Message- From: Daniele Lo Re [mailto:[EMAIL PROTECTED]] Sent: 28 January 2003 14:24 To: [EMAIL PROTECTED] Subject: SELECT & UPDATE Hi everybody. I got a really