How do I change the "& amp ;" to & in Drupal?

The following code must be executed in your database as SQL:

update table set field=REPLACE(field, '&_amp_;', '&')

Change the items in Red to Your Database Table and Your Field: Remove the Underscores from the text in blue and if you are looking for a Drupal Module to run this Query Automatically try the SQL CRON Module