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