need to do a search and replace

with mysql

[ogletree]

I have a database and I need to do a search and replace to fix some errors. I need to change EL to ELEMENTARY. I have

UPDATE `list_of_schools2` SET School_Name=replace(School_Name,’ EL’,ELEMENTARY’);

Problem is that I have some entries where the first part of a word is EL. I do know that the EL I want to change will always be the last to characters of the field. So what I need is for it to make sure not to replace it unless EL is the last 2 chars of the field.

[camble]

UPDATE `list_of_schools2` SET School_Name=replace(School_Name,’ EL’,ELEMENTARY’) where School_Name like '%EL'

[ogletree]

got the error

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'EL’,ELEMENTARY’) where School_Name like '%EL'' at line 1

[ogletree]

Never mind I got it working there were some strange characters when I copied and pasted.