Actualización de base de datos mensaje bienvenido

Para actualizar el mensaje bienvenida para cursos.

Después de encontrar el mensaje necesitas actualizar, colóquelo en la cláusula «where». Entonces ponga el mensaje que quiere actualizar en la cláusula set.

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}";