Beefy Boxes and Bandwidth Generously Provided by pair Networks
Welcome to the Monastery
 
PerlMonks  

Re: Mysql module

by Heidegger (Hermit)
on Mar 07, 2003 at 06:59 UTC ( #241081=note: print w/replies, xml ) Need Help??


in reply to Mysql module

Take the SQL sentence SELECT field1,field2 FROM my_table WHERE LEFT(field3) = '$var' and execute it in your database client (outside Perl). SQL should be tested in the database. Put a number instead of $var. BTW, I think you should select field3 before you can use it in the function LEFT(field3).

Log In?
Username:
Password:

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

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












    Results (55 votes). Check out past polls.

    Notices?