look for SUBSTRING_INDEX(field,'\.',2) -----Original Message----- From: Keith [mailto:[EMAIL PROTECTED] Sent: Thursday, March 11, 2004 8:51 PM To: [EMAIL PROTECTED] Subject: Limiting Return
g'day, 've had a good look through the manual and archives but can't find an answer. I'm pulling, among other things, a field from the DB that holds description data (a few paragrahps of text). I want to limit it so that it only pulls the first 50 words (or characters if thats not possible) Cheers, Keith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]