Have a look at this:
http://dev.mysql.com/doc/refman/5.1/en/string-functions.html#function_char-length
On Thu, Mar 10, 2011 at 9:49 AM, Ron Piggott ron.pigg...@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
On Wed, Mar 9, 2011 at 17:49, Ron Piggott
ron.pigg...@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