From: Michael Dykman Date: October 22 2010 3:31pm Subject: Re: Alphabetical pagination mysql regexp query problem List-Archive: http://lists.mysql.com/mysql/223414 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable 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 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 wrote= : >> >> You regular expression is alittle off. =A0You don't need the OR operator >> '|' inside the character class definition, it is implied. =A0Try this: >> >> [php] >> SELECT * FROM tbl where Fname REGEXP '^[abcd]' >> [/php] >> >> =A0- michael dykman >> >> On Thu, Oct 21, 2010 at 11:07 PM, bharani kumar >> 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 =A0 =A0E-H =A0 =A0 I-P =A0 =A0Q-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 t= he >> > 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 th= at >> > pager linke >> > >> > Amir >> > Amboss >> > Aron >> > Basker >> > Banu >> > hanuman >> > chithra >> > gayathree >> > chan >> > dilli >> > vasanth >> > yakee >> > >> > >> > Even i tried somthing like these query , >> > >> > cFname =A0REGEXP '^[[:<:]]a.*|b.*[[:>:]]' >> > cFname =A0REGEXP '^[[:<:]]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/ >> > >> >> >> >> -- >> =A0- michael dykman >> =A0- mdykman@stripped >> >> =A0May the Source be with you. > > > > -- > Regards > B.S.Bharanikumar > http://php-mysql-jquery.blogspot.com/ > --=20 =A0- michael dykman =A0- mdykman@stripped =A0May the Source be with you.