Removing Table Fields using Regular Expressions

I have an email field in my database I want remove some useless data.

Is creating a PHP script and running some regular expressions to remove specified data the most efficient way of doing this?

Yes you can use PHP with MySQL to remove or add data from the database. Just search for what you want to removing and make sure it exsits then delete.