Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot

Re: Mysql module

by Jazz (Curate)
on Mar 07, 2003 at 02:26 UTC ( #241060=note: print w/replies, xml ) Need Help??

in reply to Mysql module

pfaut is correct. LEFT() basically does the same thing as substr (without offset and replacement options).

LEFT( string, length )

Replies are listed 'Best First'.
Re: Re: Mysql module
by Cabrion (Friar) on Mar 07, 2003 at 02:32 UTC
    Does leaving out that parameter yeild an error message saying the problem is near `"'? I don't know. Just asking.
      mysql> select left("abcdef") -> ; ERROR 1064: You have an error in your SQL syntax near ')' at line 1 mysql> select left("abcdef",3); +------------------+ | left("abcdef",3) | +------------------+ | abc | +------------------+ 1 row in set (0.00 sec)
      --- print map { my ($m)=1<<hex($_)&11?' ':''; $m.=substr('AHJPacehklnorstu',hex($_),1) } split //,'2fde0abe76c36c914586c';

Log In?

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

How do I use this? | Other CB clients
Other Users?
Others perusing the Monastery: (3)
As of 2022-01-24 17:06 GMT
Find Nodes?
    Voting Booth?
    In 2022, my preferred method to securely store passwords is:

    Results (64 votes). Check out past polls.