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