update and select query together in mysql code example

Example: mysql update query

UPDATE table_name SET field1 = 'value 1', field2 = 'value 2'
WHERE field3 = 'value 3'