The single most powerful feature in Watch My Domains ISP is the use of SQL queries to  find, display and update domains.

You can also use SQL queries to lookup domains. The SQL options are accessible from the two ribbon-bar buttons (SQL Display & SQL Lookup). The software comes with a number of pre-created queries. You can add your own SQL queries to the list and access them with a single click.

Here is a simple SQL query to display all domains that have the word free in them.

SELECT * FROM [Domains] WHERE [Domain] LIKE ‘%free%’

Since, in Watch My Domains ISP, the first part of the query (SELECT * FROM [Domains]) is always the same, you can skip typing it in. So, the following will work.

[Domain] LIKE ‘%free%’

If you want to display only the domains that start with free, use the following

[Domain] LIKE ‘free%’

To display all domains that expire on 11/30/2009, use

[Registry Expiry] = #2009-11-30# ORDER BY [Registry Expiry]

Please note that the date format is in yyyy-mm-dd and that the date should be enclosed within a pair of #.

To find all domains that expire before 30 days from now, use

[Registry Expiry] < #[TODAY+30]# ORDER BY [Registry Expiry]

Please note that “TODAY” is not part of  regular SQL. This is an extension added in Watch My Domains ISP to make things a little easier.