如何在mysql的整个数据库表中找到电子邮件地址的存在

Question

I have 1GB mysql database. This is my company database and i have to re-factor the whole site and database.

I have changed the email address in user table but there are still some tables where email address is stored as text in some fields like html data but i don't know

Is there any way to find email pattern in all database tables and replace only that part

Answer 1

If you want to find anything that might be an email address, check out the RLIKE operator so you can use a regular expression like \b\S+\@\S+\.\w+\b to find them. It might be faster and more convenient to scan a mysqldump snapshot than the database itself.