mysql> use oscillator Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> UPDATE `product` SET `product_extended_updateable` = '1' WHERE `product_wave` =TRIM ('TN5Y10 '); ERROR 1305 (42000): FUNCTION oscillator.TRIM does not exist mysql> UPDATE `product` SET `product_extended_updateable` = '1' WHERE `product_wave` = TRIM ('TN5Y10 '); ERROR 1305 (42000): FUNCTION oscillator.TRIM does not exist mysql> UPDATE `product` SET `product_extended_updateable` = '1' WHERE `product_wave` = TRIM('TN5Y10 '); Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql>