[Solved] UPDATE syntax error for SET WHERE LIKE

by 


UPDATE `isc_products` SET `prodretailprice`=145 WHERE `prodcode` LIKE 'TSACR3'

Enclose the search pattern in single quotes.

LIKE syntax: http://dev.mysql.com/doc/refman/5.0/en/string-comparison-functions.html#operator_like

LIKE can be used with the following wildcard characters

  • % Matches 0 or more characters.
    E.g. LIKE 'TSACR3%' will match TSACR3 bla blah
  • _ Matches exactly one character.
    E.g. LIKE '_TSACR3' will match 2TSACR3 but NOT 42TSACR3

2

solved UPDATE syntax error for SET WHERE LIKE