update and select at once

[foe]

The way updates work is that they need to select the row first.... is there any way to merge select and update into one query if they both work on the same row in the same table.

Thanks in advance

[BlueMeteor]

mixed-up question

update table_name set field_name=field_value where .....

you can use where clause instead of "select "