Re: Mysql module

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

LEFT( string, length )
[download]

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.	[reply]
Re: Re: Re: Mysql module by pfaut (Priest) on Mar 07, 2003 at 02:52 UTC
`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)` [download] `--- print map { my ($m)=1<<hex($_)&11?' ':''; $m.=substr('AHJPacehklnorstu',hex($_),1) } split //,'2fde0abe76c36c914586c';` [download]	[reply] [d/l] [select]