RE: [PHP-DB] Cutting strings
| From: | Peter Lovatt | Date: | Sun, 26 Jan 2003 09:47:28 +0000 |
| Subject: | RE: [PHP-DB] Cutting strings | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25143@lists.php.net to get a copy of this message | ||
Hi
from the manual
http://www.mysql.com/doc/en/String_functions.html
LEFT(str,len)
Returns the leftmost len characters from the string str:
mysql> SELECT LEFT('foobarbar', 5);
-> 'fooba'
HTH
Peter
-----Original Message-----
From: Chezney [mailto:chz@new.co.za]
Sent: 26 January 2003 09:08
To: php-db@lists.php.net
Subject: [PHP-DB] Cutting strings
Hi
I have values in my table but for one of the fields I would only like to
display the first 5 chars instead of 15 how is this possiable?
--
Kind Regards,
Chezney
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php