MySQL - Adding a string to a text column

Question

I'm trying to add a text string to certain columns. This is a query I've tried, it failed miserably though, but it explains what I want to do.

SET @NAME = (Select name from item_template where itemset = 801);
SET @NEWNAME = ('|cFFFF0000'+@NAME);
Update item_template set name = @NEWNAME where itemset = 801;

Thanks in advance! :)

Borgtex · Accepted Answer · 2012-08-01 19:26:32Z

1

Why not just

update item_template set name = concat('|cFFFF0000',name) where itemset = 801;

answered Aug 1, 2012 at 19:26

Borgtex

3,2551 gold badge21 silver badges28 bronze badges

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

Comments

juergen d · Accepted Answer · 2012-08-01 19:30:48Z

0

try

Update item_template
set name = (select * from (select concat('|cFFFF0000', name) 
                           from item_template
                           where itemset = 801) x
           ) 
where itemset = 801;

or even shorter

Update item_template
set name = concat('|cFFFF0000', name) 
where itemset = 801;

edited Aug 1, 2012 at 19:30

answered Aug 1, 2012 at 19:25

juergen d

205k40 gold badges303 silver badges377 bronze badges

Comments

jcho360 · Accepted Answer · 2012-08-01 19:56:22Z

0

SET @NEWNAME = ('|cFFFF0000'+@NAME);

use concat

SET @NEWNAME := CONCAT('|cFFFF0000',@NAME);

edited Aug 1, 2012 at 19:56

answered Aug 1, 2012 at 19:22

jcho360

3,7491 gold badge18 silver badges25 bronze badges

Collectives™ on Stack Overflow

MySQL - Adding a string to a text column

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related