Unveiled wildcard ' := ' in mysql

Hi,


update some_table
set col = col + 1
where key = 'some_key_value'
and @value := col_name


In this statement operator := will be always evaluated as TRUE no matters and second thing  it will store the value of the updated row before updation (dat means before updation what the value was).In query we can use for swapping