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