[PHP-DB] Limit chars from select

2006-01-29 Thread Gavin Amm
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

RE: [PHP-DB] Limit chars from select

2006-01-29 Thread Gavin Amm
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 you want to limit the characters from an individual field? If so, then SELECT

Re: [PHP-DB] Limit chars from select

2006-01-29 Thread John Meyer
-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 the