List:General Discussion« Previous MessageNext Message »
From:bharani kumar Date:October 22 2010 3:07am
Subject:Alphabetical pagination mysql regexp query problem
View as plain text  
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/

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