Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked
 
PerlMonks  

Re: (OT) Setting up a MySQL REGEXP in Perl

by edoc (Chaplain)
on Jan 31, 2005 at 14:44 UTC ( #426617=note: print w/replies, xml ) Need Help??


in reply to (OT) Setting up a MySQL REGEXP in Perl

you need to change the ordering of the statement I believe..

$stmt = "SELECT * FROM teamnew WHERE lastname REGEXP '^$1|^$2|^$3' ORD +ER BY lastname";

cheers,

J

Replies are listed 'Best First'.
Re^2: (OT) (OT) Setting up a MySQL REGEXP in Perl
by bradcathey (Prior) on Jan 31, 2005 at 17:15 UTC

    edoc, thanks, that was it. I didn't think the order mattered, but by moving "ORDERED BY lastname" to the end of the statement, all was fine.


    —Brad
    "The important work of moving the world forward does not wait to be done by perfect men." George Eliot

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://426617]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (3)
As of 2022-01-24 10:36 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:












    Results (64 votes). Check out past polls.

    Notices?