You regular expression is alittle off. You don't need the OR operator '|' inside the character class definition, it is implied. Try this:
[php] SELECT * FROM tbl where Fname REGEXP '^[abcd]' [/php] - michael dykman On Thu, Oct 21, 2010 at 11:07 PM, bharani kumar <bharanikumariyer...@gmail.com> wrote: > 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/ > -- - michael dykman - mdyk...@gmail.com May the Source be with you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
