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