Re: in mysql,is there a quesry like update table set filed as normal?

[Peter Brawley]

Are you trying to ask whether there is an Update syntax that does nothing if it finds the specified value already there? You can write ...

update tbl set col=val where col<>val;