List:General Discussion« Previous MessageNext Message »
From:bharani kumar Date:October 22 2010 3:01pm
Subject:Re: Alphabetical pagination mysql regexp query problem
View as plain text  
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 <mdykman@stripped> 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
> <bharanikumariyerphp@stripped> 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
>  - mdykman@stripped
>
>  May the Source be with you.
>



-- 
Regards
B.S.Bharanikumar
http://php-mysql-jquery.blogspot.com/

Thread
Alphabetical pagination mysql regexp query problembharani kumar22 Oct
  • Re: Alphabetical pagination mysql regexp query problemMichael Dykman22 Oct
    • Re: Alphabetical pagination mysql regexp query problembharani kumar22 Oct
      • Re: Alphabetical pagination mysql regexp query problemMichael Dykman22 Oct