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 the rows in a table where the length of a field, lets say
> field1 is a minimum of 60 characters or larger. The field type is 
varchar.

> Thanks,

> Ed


You were SO close!!!

SELECT <field list>
FROM <table references>
WHERE CHAR_LENGTH(varcharfield) >= 60;

http://dev.mysql.com/doc/mysql/en/string-functions.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine

Reply via email to