is there a way to SELECT * from table that="whatever" and then automatically UPDATE those same fields with a new value? I could test it, but was wondering if anyone knows before I do if it would work.
No need to do a select.
UPDATE table_name SET column_name='new value' WHERE column_name='old value'
