Cleaning up bad data in an SQL database
Recently, I needed to find all of the data in a table that was being used for HTML output, that had non-printable characters. The following SQL statement should do that for you:
select id, name from table_name where name not regexp '^[a-zA-Z0-9_ ,&;\/<>(²):%*#?$|!+.\"\'-]+$;
This code is MySQL specific, but should be applicable anywhere, really.
Related posts:
- How to fix strange characters in MySQL database – Vinh Pham I admit, I borrowed this from How to fix strange...
- Databases and backups Yesterday, I managed to delete the primary database that we...
- gms8994′s benchmark at master – GitHub I’ve recently been posting my benchmark scripts to github. You...
