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