Am just trying alphabetical pagination ,
Yes there is lot of pager class there for this ,
but in my requirement little but diff , that is
totally 4 sets ,
A-D E-H I-P Q-S (Assume there are pager links)
When user click the A-D , then it should show all the customer name starting
with A , B, C, D names should be pull out ,
For that i just used this REGEXP QUERY ,
SELECT * FROM tbl where Fname REGEXP '^[a]'
This works fine, only rendering the starting with "a" Names ,
But if i add the or condition in that
SELECT * FROM tbl where Fname REGEXP '^[a|b|c|d]'
This condition not working, the output for the above query , pullout the all
records starting wiht what ever,(A-z)
So What i want is,
if i hit A-D the it should pullout only matched character
but my out put should not like , because this not exact records for that
Even i tried somthing like these query ,
cFname REGEXP '^[[:<:]]a.*|b.*[[:>:]]'
cFname REGEXP '^[[:<:]]a.*|b.*'
If i add the OR condition in the REGEXP , then displaying unwanted records,
Also main thing , i want solution for case insensitive ,