SQL Update - Adding to String to One Attribute

Question

My mysql table is : Product (name,price,metaDescription)

I want to write an SQL UPDATE to Set my metaDescription name+' is only just for'+metaDescription

I tried this but it didn't work

UPDATE 
  product 
SET 
  metaDescription=name+' is just for'+price;

mu is too short · Accepted Answer · 2011-06-27 09:04:34Z

1

You should use the concat function:

update product
set metaDescription = concat(name, ' is just for ', price);

MySQL should automatically convert price to a string type for you.

MySQL is trying to convert your strings to numbers (and silently failing) when you use +:

mysql> select 'this' + 'that';
+-----------------+
| 'this' + 'that' |
+-----------------+
|               0 |
+-----------------+

answered Jun 27, 2011 at 9:04

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1