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