[sqlalchemy] SQL to sqlalchemy help

Hi All, I have been trying to covert this sql query to sqlalchemy one for hours now with no luck. any help will be appreciated update table1 set columnValue=(case when columnValue=A then B when columnValue=B then A end) where columnValue in (A,B); It is just swapping the columnValue where its

Re: [sqlalchemy] SQL to sqlalchemy help

On Mar 1, 2011, at 9:14 PM, eddy wrote: Hi All, I have been trying to covert this sql query to sqlalchemy one for hours now with no luck. any help will be appreciated update table1 set columnValue=(case when columnValue=A then B when columnValue=B then A end) where columnValue in