Database update welcome message

To update the welcome message for courses.

After finding the message you need updated put this as the where clause. Then put the message you want to update to in the set clause.

update mdl_lp_enrol_email 
set body = "***Welcome to
{coursename}
!***
You have been assigned this course as part of your mandatory/personal development training.
Please log in to complete this module as soon as possible. 
If you have any queries please contact a member of the Learning Development team.
{profileurl}"
where body = "Welcome to {coursename}!

If you have not done so already, you should edit your profile page
within the course so that we can learn more about you:

  {profileurl}";