josiespencer
11-18-2007, 08:22 PM
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.
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.