How to implement pagination on number and alphabet at the same time [CI3]

I think you will have to do as you say: select all the titles and find the right page number.
But you can cache the result for better performance and not do this at each page load: https://www.codeigniter.com/user_guide/l...ching.html

Thank you for your suggestion. and sorry about example link ;-;