http://qs321.pair.com?node_id=241060


in reply to Mysql module

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

LEFT( string, length )

[download]

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]
      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]

In Section Seekers of Perl Wisdom