Hi everybody

I am not the best sql developer but can help myself a bit.
Bu i am stuck converting this update query to a trigger. I want to update a contacts_cstm field with a 0 value the moment someone unsubscribes from a newsletter. Any help will be appreciated.
Regards

Paul



UPDATE
savanadev.prospect_lists_prospects
LEFT JOIN savanadev.contacts_cstm
ON (prospect_lists_prospects.related_id = contacts_cstm.id_c)
SET contacts_cstm.ad101_c = '0'

WHERE prospect_lists_prospects.prospect_list_id = '5a32f398-d896-81bf-47d6-4c7b975ce278'
AND prospect_lists_prospects.date_modified >= CURDATE()
AND MONTH(prospect_lists_prospects.date_modified) >= MONTH(CURDATE())
AND YEAR(prospect_lists_prospects.date_modified) >= YEAR(CURDATE())
AND prospect_lists_prospects.deleted <> '1';