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