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