MySql search for string in column 'X' and insert string in column 'Y'

Question

I am very new to MySql and I am having a lot of trouble with the syntax. I am looking for a query that will do the following.

if string 'abc' is present in any row of column 'X', then insert string 'def' into column 'Y', only in the same rows that contain 'abc' in column 'X'.

I have tried a few different statements but i continue to receive syntax errors. Hopefully I have explained this clearly enough in pseudo

I think `update table set y = 'def' where x like '%abc%'` would do it. Show your code and errors, then we can help. — chris85, Dec 15 '16 at 05:09

score 0 · Answer 1 · answered Dec 15 '16 at 05:11

0

Try to use this query (plz change tablename, column X,Y):

update tablename set Y='def' where X like '%abc%';

answered Dec 15 '16 at 05:11

Vikas Umrao

2,800
1
15
23

MySql search for string in column 'X' and insert string in column 'Y'

1 Answers1