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: 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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
