Simple MYSQL Select Queries

  • Published by steve on 28 December 2011.

Version: MySQL 5.0
Database Name: testdb
Table Name: domains
Field Name: domainame

Simple Select Query #1

Show all domain names that do not contain a zero digit.

SELECT * FROM `domains` WHERE `domainame` NOT LIKE '%0%'