SQL Display Options in Watch My Domains ISP

SQL queries provide a very powerful method for manipulating domain names in the database. Watch My Domains ISP supports creating your own customized SQL queries for different purposes. You can create a list of different SQL queries and save them for use later.

SQL queries may be used to display or lookup domains based on different criteria. For example, you can create an SQL query that will redo the lookups on all domains that have not been looked up within the last 65 days and whose expiry date falls within the next 10 days and so on.

See the following screen shots and the associated tips for getting a clear idea about SQL queries in Watch My Domains ISP.

You can also use SQL queries looking up domains.

Quick SQL Queries using "Find" (Ctrl-F)

You can press Ctrl-F within the Domain Manager to execute a number of quick SQL display queries. These are mainly queries to find domains that match a condition.

There is a "Show SQL" button that allows you to see the actual SQL query that will be used. You can use it to get ideas for creating custom SQL queries.

SQL Query Setup

You can use the SQL Display ribbon button to edit and / or create SQL queries. The software has a number of sample SQL queries.

Please see Optimized SQL Lookups for tips on creating SQL queries.

Remember to name your queries properly. These names will appear in the domain category tree.

SQL Query Editor

The SQL query editor is available from the "Modify" or "New" buttons within the SQL Display or SQL Lookup dialog.

Simply type in your SQL query into the box for that purpose. You can use the keyword [TODAY] to indicate the current date.

The Field Names table lists all the existing field names in the currently open database.

SQL Execution

Use the "SQL Display Queries" branch in the Domain Category Tree to select and execute an SQL query.