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