MySQL Forums
Forum List  »  Newbie

Re: how do i use update in a select query
Posted by: Razvan Licaret
Date: August 14, 2016 02:56PM

Hi,
that would've probably worked as well, even though I don't completely understand the syntax...
I had just replied to DJ L that I had finally done it this way:

UPDATE `mzm8e_jomcl_extrafields_values` INNER JOIN `mzm8e_jomcl_adverts` ON `mzm8e_jomcl_extrafields_values`.`advertid` = `mzm8e_jomcl_adverts`.`id` SET value = 2 WHERE (`mzm8e_jomcl_adverts`.`userid`) = 5560 AND (`mzm8e_jomcl_extrafields_values`.`fieldid`) = 5

Many thanks to both of you for trying to help!

Options: ReplyQuote


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


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.