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 la
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 Firstnam
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
wrote:
> Hi ,
>
> Am just try
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-DE-H I-PQ-S (Assume there are pager links)
When user click the A-D , then it should show all the customer name starting
