[snip] Is there a way to check if a field has x number of characters in it?
I have a table with a column (phone) which, for the moment is varchar(25). I need to find those entries which have less than 10 characters. [/tuck] http://www.mysql.com/doc/en/String_functions.html mysql> SELECT LENGTH('text'); -> 4 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
