Re: Limit chars from select

[John Meyer <john.l.meyer@xxxxxxxxx>]

Gavin Amm wrote:
> How do I limit the characters a Select statement returns?
> In Seudo code:
> SELECT * FROM myTable LIMITCHARS 30;
> 
> I'm using MySQL.
> 
> Thanks.
> 

Do you want to limit the characters from an individual field?  If so, then

SELECT SUBSTRING(FIELD1 FROM 1 FOR 30) FROM myTable;

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php