From: Michael Dykman
Date: October 22 2010 3:25am
Subject: Re: Alphabetical pagination mysql regexp query problem
List-Archive: http://lists.mysql.com/mysql/223409
Message-Id: <AANLkTi=x3q3=M9tqhcRfyRHyBZ4LgScteaCy-pXwQ_i2@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

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 =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 start=
ing
> 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 =A0REGEXP '^[[:<:]]a.*|b.*[[:>:]]'
> cFname =A0REGEXP '^[[:<:]]a.*|b.*'
>
>
> If i add the OR condition in the REGEXP , then displaying unwanted record=
s,
>
>
> Also main thing , i want solution for case insensitive ,
>
> Thanks
>
> --
> Regards
> B.S.Bharanikumar
> http://php-mysql-jquery.blogspot.com/
>



--=20
=A0- michael dykman
=A0- mdykman@stripped

=A0May the Source be with you.