Re: SELECT WHERE length of content question
| From: | Daniel Brown | Date: | Wed, 09 Mar 2011 23:38:38 +0000 |
| Subject: | Re: SELECT WHERE length of content question | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47717@lists.php.net to get a copy of this message | ||
On Wed, Mar 9, 2011 at 17:49, Ron Piggott
<ron.piggott@actsministries.org> 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/