Beefy Boxes and Bandwidth Generously Provided by pair Networks
Do you know where your variables are?
 
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
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?
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 avoiding work at the Monastery: (9)
As of 2015-07-30 07:06 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The top three priorities of my open tasks are (in descending order of likelihood to be worked on) ...









    Results (270 votes), past polls