Truncated incorrect DOUBLE value when updating mysql column

Question

when trying to update my mysql database-column with following sql command

UPDATE db.vendor_horses SET image='{"images":["' + image  + '"]}';

I get following error:

UPDATE db.vendor_horses SET image='{"images":["' + image + '"]}'    Error Code: 1292. Truncated incorrect DOUBLE value: '{"images":["'  0.00028 sec

I can't figure out what's wrong..

Answer 1

in mysql + is not valid concatenation sign. (MySQL concatenation operator) you should use CONCAT function.

UPDATE db.vendor_horses SET image= CONCAT('{"images":["', image, '"]}';