Friday, April 20, 2012

mysql update all columns which has value say 'ram'

I have many columns in a table which needs to be checked against some value and values needs to be replaced if match found..



So basically I am looking for a query which takes column name as sort of variable and loops through the table and updates the column value if matched..



I could do that with php, having as many quries as columns..But thats wat i dont want..





No comments:

Post a Comment