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