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