Try: $sql = "SELECT LEFT(columnName,255) FROM tableName"; Using that syntax should return the first 255 characters from the selected column, reading LEFT to right. I tested it in the command line and it worked just fine. Hope that helps. Rich > -----Original Message----- > From: Marie Osypian [mailto:mosypian@savingforcollege.com] > Sent: Friday, June 20, 2003 3:06 PM > To: php-db@lists.php.net > Subject: Limit return Size > > > I would like to know how I limit my answer from a mysql > database query to > display only a limited size? Is this done in the query or the php? > > i.e. Our Performance Results area includes First Quarter > 2003 investment > returns for virtually every 529 savings programs. See how > your 529 plan > performed... > > This question is alot longer but it was stopped and ... added when it > reached the desired size. > > Thanks > > MAO > > > > -- > 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
