Re: Moving Value from One Column to Another if first character is $

[Peter Brawley]

Incomplete spec. You need to specify which if any existing `bail` values are to be overwritten, and what is to happen to existing `10_percent` values.

Assuming the requirement is to overwrite existing `bail` values and remove existing `10_percent` values you are moving, and assuming the columns are strings ...

update tbl set `bail`=`10_percent`,`10_percent=''
where left('10_percent`,1)='$';