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