Text length query

[riluve]

I am using MYSQL and I need to run a query on a table where I can serch for records only with a text feild of a specified length (number of characters) e.g.

SELECT *
FROM table
WHERE length('text_field') > x

Anyone know the proper syntax?

 

[PHV]

The ANSI function is CHAR_LENGTH:
SELECT *
FROM table
WHERE CHAR_LENGTH(NameOfColumn) > x

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[riluve]

SWEET! - thnx