Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister
 
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 cooling their heels in the Monastery: (5)
As of 2015-07-05 19:40 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 (67 votes), past polls