Simple MYSQL Select Queries

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%'

Add new comment