I want to add an entry to the Execute SQL Query drop down

[josiespencer]

In which table are these entries stored? I have one query I use every day to do user confirmation. It is this one:

SELECT username, email, ipaddress, birthday FROM user
WHERE username LIKE "%<name>%" OR email LIKE "%<name>%"
ORDER BY birthday;

How can I add this to the queries with the "canned" queries that come with vBulletin? It is a pain typing it everyday.

[Marco van Herwaarden]

These are hard coded.

I once made a modification for this, see my profile.