I am attempting to update a number of rows in a MySQL table with values from other rows within the same table and my attempts have failed. My attempt is below however it delivers the error message listed below the query.
UPDATE `Table` set `field_value` =
(SELECT `field_value` FROM `Table` WHERE `field_name` = 'xyz')
WHERE `field_name` = 'abc'
#1093 - You can't specify target table 'Table' for update in FROM clause
Basically I am attempting to use the Select Query to create the variable to use in the update Query.
Is this at all possible?