Re: [PHP-DB] Limit chars from select

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Gavin Amm wrote: > I'd like to avoid having to manually add all of the cols to the select > statement if possible, so if there's a universal command I can put in > that'd be best. In that case, what I would do is just do your SELECT statement, sans th

RE: [PHP-DB] Limit chars from select

30, 2006 12:51 PM To: Gavin Amm; php-db@lists.php.net Subject: Re: [PHP-DB] Limit chars from select 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 yo

Re: [PHP-DB] Limit chars from select

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-DB] Limit chars from select

How do I limit the characters a Select statement returns? In Seudo code: SELECT * FROM myTable LIMITCHARS 30; I'm using MySQL. Thanks. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php