in my database,
if i want to render firstname and lastname match case , am using REGEXP '^[abcd]' WORK FOR SINGLE FIELD, Now i have fname and lastname , How to make the query , which display both and single field satisfieds records , That is my query should return like Name(combined Firstname and lastname) Abbas, Ajai, Ashok,Amar, Abdul,Baskar, Abdul,cagan, Arun,Deena Any ideas On Fri, Oct 22, 2010 at 8:55 AM, Michael Dykman <mdyk...@gmail.com> wrote: > 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. > -- Regards B.S.Bharanikumar http://php-mysql-jquery.blogspot.com/