SELECT id FROM users WHERE active=1 AND about_me LIKE "%hip hop writing mcing smoking extasy cs rLx%" ORDER BY username ASC, num_followers DESC
0.04250
SELECT id FROM users WHERE tags REGEXP "(^|\,| )hip hop writing mcing smoking extasy cs rLx($|\,)" ORDER BY username ASC
0.01060
SELECT id FROM users WHERE active=1 AND (username LIKE "%hip hop writing mcing smoking extasy cs rLx%" OR fullname LIKE "%hip hop writing mcing smoking extasy cs rLx%" OR position LIKE "%hip hop writing mcing smoking extasy cs rLx%") ORDER BY username ASC
0.00935
SELECT id FROM users WHERE active=1 AND (username="hip hop writing mcing smoking extasy cs rLx" OR fullname="hip hop writing mcing smoking extasy cs rLx" OR position="hip hop writing mcing smoking extasy cs rLx") ORDER BY username ASC