I want to search and replace multiple values in a table column in one MYsql querry.
- by user204245
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.
