Watch My Domains ISP supports creation of  dynamic SQL queries that prompt you for an input and then use whatever you typed in as part of the SQL query.

Here is how you do it.

[Domain] LIKE ‘%{UITEXT:SQL Domain Query|Locate Domains That Match:}%’

The above will popup a box similar to the one shown in the screen shot.

Whatever you type in is used to complete the actual SQL query. So, if you typed in

free

the generated SQL will be

[Domain] LIKE ‘%free%’

There are cases when you want to use the user input in multiple places within the same SQL. The following SQL query does this.

[NS1] LIKE ‘%{UITEXT:SQL NS Query|Locate Name Servers That Match:}%’ OR [NS2] LIKE ‘%{UITEXT:}%’ OR [NS3] LIKE ‘%{UITEXT:}%’

If you typed in dns0, the generated SQL query will be

[NS1] LIKE ‘%dns0%’ OR [NS2] LIKE ‘%dns0%’ OR [NS3] LIKE ‘%dns0%’

This will display all domains whose NS1, NS2 or NS3 records contain the term dns0.