[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Re: Alphabetical pagination mysql regexp query problem
From:       Michael Dykman <mdykman () gmail ! com>
Date:       2010-10-22 15:31:09
Message-ID: AANLkTikQBp5S7Lo6KAXgwuryXXtDnY+wdxcOL=y0YnQg () mail ! gmail ! com
[Download RAW message or body]

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
<bharanikumariyerphp@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 <mdykman@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
>> <bharanikumariyerphp@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
>>  - mdykman@gmail.com
>>
>>  May the Source be with you.
>
>
>
> --
> Regards
> B.S.Bharanikumar
> http://php-mysql-jquery.blogspot.com/
>



-- 
 - michael dykman
 - mdykman@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=mysql-marcsub@progressive-comp.com


[prev in list] [next in list] [prev in thread] [next in thread]