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