MySQL Forums
Forum List  »  Newbie

Re: how do i use update in a select query
Posted by: Peter Brawley
Date: August 14, 2016 02:52PM

Is this what you mean?

UPDATE mzm8e_jomcl_extrafields_value AS v
JOIN mzm8e_jomcl_adverts AS a ON a.id=v.advertid
SET v.value = 2
WHERE a.userid=5560 AND v.fieldid=5;

Options: ReplyQuote


Subject
Written By
Posted
Re: how do i use update in a select query
August 14, 2016 02:52PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.