On Wed, Mar 9, 2011 at 17:49, Ron Piggott
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
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 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?
>
> OR
>
> D
Is there a command in mySQL that would allow me to SELECT the rows where the
`fax` column is more than 11 characters long?
OR
Do I need to use PHP to assess this?
Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info
