I've looked around and believe this to not be possible, but am checking just to be
sure.
Basically I want to run the command
UPDATE MyTable SET SomeRecord = NewValue WHERE SomeRecord = OldValue
But, I need to know which rows were modified, not simply how many. So far this is the
best that I
Hi Jason,
If I understand correctly you need the SELECT statement first to detemine
which records to update. However perhaps on the SELECT statement you could
speed up things by showing only the required columns and not all. While this
doesnt make a big difference for small tables, it can make
# [EMAIL PROTECTED] / 2003-06-24 01:02:17 -0600:
But, I need to know which rows were modified, not simply how many. So
far this is the best that I have come up with
LOCK TABLES MyTable WRITE
SELECT * FROM MyTable WHERE SomeRecord = OldValue
UPDATE MyTable SET SomeRecord = NewValue WHERE