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