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