How to concat and update at the same time while using a where clause?

Question

update discountLinks set tag=concat(tag, '-on') where free_trial_period_month is not null;

I am getting an Unknown column error.

berty · Accepted Answer · 2015-08-20 19:05:21Z

1

Your syntaxs is correct, one of the tag or the free_trial_period_month column probably does not exist in the table discountLinks

answered Aug 20, 2015 at 19:05

berty

2,20612 silver badges20 bronze badges

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

1 Comment

Yeah, it was free_trial_month_period