Re: Finding row by value of a certain length

2005-06-22 Thread Ed Curtis
On Wed, 22 Jun 2005 [EMAIL PROTECTED] wrote: > You were SO close!!! > > SELECT > FROM > WHERE CHAR_LENGTH(varcharfield) >= 60; Thanks so much. I knew I was close but couldn't remember the exact command. Ed -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To u

Re: Finding row by value of a certain length

2005-06-22 Thread SGreen
Ed Curtis <[EMAIL PROTECTED]> wrote on 06/22/2005 02:27:02 PM: > I've been cruising the docs for a while now and can't find what I'm > looking for. I know it has soemthing to do with value or LEN or something > easy like that but I just can't find the right command structure. > I need to list th

Finding row by value of a certain length

2005-06-22 Thread Ed Curtis
I've been cruising the docs for a while now and can't find what I'm looking for. I know it has soemthing to do with value or LEN or something easy like that but I just can't find the right command structure. I need to list the rows in a table where the length of a field, lets say field1 is a mini