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