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