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