SELECT id FROM users WHERE active=1 AND about_me LIKE "%#DoubleJeopardy%" ORDER BY username ASC, num_followers DESC
0.00920
SELECT id FROM users WHERE tags REGEXP "(^|\,| )#DoubleJeopardy($|\,)" ORDER BY username ASC
0.01309
SELECT id FROM users WHERE active=1 AND (username LIKE "%#DoubleJeopardy%" OR fullname LIKE "%#DoubleJeopardy%" OR position LIKE "%#DoubleJeopardy%") ORDER BY username ASC
0.01158
SELECT id FROM users WHERE active=1 AND (username="#DoubleJeopardy" OR fullname="#DoubleJeopardy" OR position="#DoubleJeopardy") ORDER BY username ASC