Hi , 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 , [php] SELECT * FROM tbl where Fname REGEXP '^[a]' [/php] This works fine, only rendering the starting with "a" Names , But if i add the or condition in that [php] SELECT * FROM tbl where Fname REGEXP '^[a|b|c|d]' [/php] 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 example Amir Amboss Aron Basker Banu chithra chan dilli but my out put should not like , because this not exact records for that pager linke Amir Amboss Aron Basker Banu hanuman chithra gayathree chan dilli vasanth yakee 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 , Thanks -- Regards B.S.Bharanikumar http://php-mysql-jquery.blogspot.com/