Problem:

I want to create a rule to send an email to a user for every action that occurs in the Issue, what SQL would do this?

Resolution:

ANSWER
----------------------------------
The following SQL rule sends an email to Mike, the person who logged the defect. Mike will receive an email regardless of the action performed by other users in this defect. For example if the defect changes state, gets reassigned, someone adds a comment, an attachment is added etc then an email will be send to Mike.

D.UserCreated = "Mike" and DH.ActionCode like "%"

Once you add this rule just create an email trigger, assign it to this rule and make the user (in this case Mike) the recipient of the email.