Creating Trigger.. New to this obviously

[Colin Haime]

I am trying to create a trigger to change a download link in my database.

The program I am using is creating a download link pointing to the wrong directory. After a new record is created I want to change the incorrect potion of the download URL to the correct one. I was hoping to create a trigger to do this.

I have written it as follows

CREATE TRIGGER Update_Directory AFTER INSERT ON wpin_gm_user_entries UPDATE wpin_gm_user_entries SET download_link = REPLACE(download_link, 'uploads', 'gravity2pdf') ;

If I run the update command manually as an sql command it works. If I run it as part of a Trigger it does not.

Am I attempting the impossible or is something else wrong?

Thanks in advance.