Version: MySQL 5.0 Database Name: testdb Table Name: domains Field Name: domainame
Show all domain names that do not contain a zero digit.
SELECT * FROM `domains` WHERE `domainame` NOT LIKE '%0%'