On Wed, Mar 9, 2011 at 17:49, Ron Piggott
<ron.piggott@xxxxxxxxxxxxxxxxxx> wrote:
>
> Is there a command in mySQL that would allow me to SELECT the rows where the `fax` column is more than 11 characters long?
There is.
SELECT * FROM tblName WHERE CHAR_LENGTH(fax) >= 11;
(Presuming you meant greater than or equal to eleven, as in an
invalid US/Canadian phone number.)
--
</Daniel P. Brown>
Network Infrastructure Manager
http://www.php.net/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
