MySQL makes stuff easy
Recently, had to
MIGRATE `some`, `product`, `tables` FROM `different sources` WHERE `someone apparently typed letters in fields that were supposed to hold numbers only`;
Only problem: the table holds nearly 3000 rows.
So I used a regular expression:
SELECT * FROM `products` WHERE `price` REGEXP '[:alnum:]';
It took 0.0434 sec for MySQL to identify the badboys
