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