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