Need help with a mySQL query

[JamesAB]

I'm trying to update Thread Subscriptions so nobody that registered with an e-mail address from domainxyz.com gets e-mail updates.

Something like:

UPDATE " . TABLE_PREFIX . "subscribethread
		SET emailupdate = 0
		WHERE (emailupdate > 0)
			AND ?????????

I'm just not familiar enough with queries to know how to test against a users e-mail address.

I'm looking to compare it like this:

AND (email LIKE "%domainxyz.com")

I imagine I need to join the user and subscribethread tables but I'm unsure of the proper syntax.

Any help would be appreciated.

Thanks,
James

[kh99]

This should work:

"UPDATE " . TABLE_PREFIX . "subscribethread as subscribethread
   LEFT JOIN " . TABLE_PREFIX . "user as user ON(subscribethread.userid=user.userid)
		SET emailupdate = 0
		WHERE (emailupdate > 0) AND email LIKE '%domainxyz.com' "

[JamesAB]

That works great.
Thank you very much!