> Is there a simple wat to get a word count out of a field in mysql, or to at > least split on " " and tell me how many items in that array.
Well, you can count the number of spaces: SET @str = 'A four word sentence'; SELECT LENGTH( @str ) - LENGTH( REPLACE ( @str , ' ', '' ) ) +1; Maybe this is good enough? Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]