need correct syntax for update / replace a table entry when column_id name is 'value'

Question

I need to replace a value in a magento store database table where the name of the column is 'value' - that's what is confusing me!!

Table name = catalog_product_entity_varchar
column ID = value
value to replace = container2
value to become = container1

what syntax should I use?

This is very basic stuff. Since you had to ask, I've heard good things about the book, Teach Yourself SQL in 10 Minutes. — Dan Bracuk, May 24 '14 at 12:03

echo_Me · Accepted Answer · 2014-05-24T12:19:39.463

0

althoug this is basic UPDATE.

 UPDATE catalog_product_entity_varchar SET `value` = 'container1'
 WHERE `value` = 'container2'

edited May 24 '14 at 12:19

answered May 24 '14 at 11:36

echo_Me

thanks - that's what i tried first, and just thought it's because i've only had 3 hours sleep in 3 days... lol but it returns this error #1054 - Unknown column 'container2' in 'where clause' – mschf-maker May 24 '14 at 12:17

1 Answers1