Beefy Boxes and Bandwidth Generously Provided by pair Networks
"be consistent"
 
PerlMonks  

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 )


Comment on Re: Mysql module
Download Code
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?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (6)
As of 2014-07-10 01:59 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (198 votes), past polls