UPDATE Templates SET html='

Certificate Of Completion

This is to certify that

.{{firstName}} .{{lastName}}

has successfully completed the course

.{{assessmentName}}

Date

.{{date}}

Certificate No.

.{{certificateNumber}}

' WHERE name='__Certification-Assessment-Template__'; update Templates set html = '

Certificate Of Completion

This is to certify that

.{{firstName}} .{{lastName}}

has successfully completed the course

.{{courseName}}

Date

.{{date}}

Certificate No.

.{{certificateNumber}}

' where name='__Certification-Template__';