You would have to use more queries your way
- SELECT * FROM advertisers WHERE packageType=1 LIMIT $limitMin, $perPage
- SELECT COUNT(*) FROM advertisers WHERE packageType=1
- SELECT COUNT(*) FROM advertisers WHERE packageType=2
You need the last two to be able to figure out the details of pagination
Why don't you add the index, convert the column to INT and see how it works with ORDER BY and LIMIT?
I created a website once that currently has some 180.000 rows in one table, and also uses an ORDER BY on an INT value and a LIMIT, and it's still fast.