[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.