Updating multiple fields at once
I'm trying to find all instances of the word true throughout the table and change them to a '1'.  To save time in the future, I'd like to be able to change every column at once and only run one query.  

`update myTable
set field1, field2, field3=1
where field1, field2, field3='true'`

that's kinda what i'm looking at doing. 
Updating multiple fields at once
===

I'm trying to find all instances of the word true throughout the table and change them to a '1'.  To save time in the future, I'd like to be able to change every column at once and only run one query.  

`update myTable
set field1, field2, field3=1
where field1, field2, field3='true'`

that's kinda what i'm looking at doing. 