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