I want to search and replace multiple values in a table column in one MYsql querry.
Posted
by user204245
on Stack Overflow
See other posts from Stack Overflow
or by user204245
Published on 2010-04-24T21:09:06Z
Indexed on
2010/04/24
21:13 UTC
Read the original article
Hit count: 285
Query to Where X update Y and where A update B in a Mysql Table column.
How can I Do this in MYsql in one querry on the same column in a specific table. I want to search and replace multiple values in a table column.
Conditons in table1 in column1
Where X update Y and Where a update b and Where 1 update 2 and Where 3 update 4 and Where value1 update value 2
And So on.
I can individually do this but how can I do this faster is there a mysql function to help me with this. I have about 120 columns with 200 search and replace/update values for each column.
Thanks.
© Stack Overflow or respective owner
