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