Is this what you meant? SELECT * FROM tbl where Fname REGEXP '^[abcd]' AND Lname REGEXP '^[abcd]'
(alternatively, the extression could be simpliefied as "REGEXP '^[a-d]" ) - md On Fri, Oct 22, 2010 at 11:01 AM, bharani kumar <bharanikumariyer...@gmail.com> wrote: > 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/ > -- - 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