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