Concatinating query strings in mysql

Question

I am writing a trigger in mysql and my trigger is given below:

$sql="CREATE TRIGGER insert_cats AFTER INSERT ON tbl_categories
   FOR EACH ROW
   BEGIN
   insert into tbl_routes set fld_route_name='cat_' + //here i want to concatinate
   NEW.fld_name,fld_route_info='dynamic/route/info';
   end;
";

i want to concat string 'cat_' with New.fld_name. I tried CONCAT but i came to know it concatinates two columns and also tried + and . operator but nothing happen... Please help....

Denys Séguret · Accepted Answer · 2013-05-31 10:58:07Z

1

Use concat, it works with a literal and a column too :

concat('cat_', New.fld_name)

answered May 31, 2013 at 10:58

Denys Séguret

384k90 gold badges813 silver badges780 bronze badges

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

Collectives™ on Stack Overflow

Concatinating query strings in mysql

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related