Hi - NW> I have a table (for example) with three cols 'id' | 'date' | 'text' NW> I want to return just 'date' and the first 30 chars from 'text'
NW> I've tried this sql: NW> SELECT date, SUBSTRING(text, 0,30) as description FROM table WHERE id = NW> '2'; Start with position 1. SELECT datefield, SUBSTRING(textfield, 1, 30) as description FROM tablename WHERE id = 2; - Julie --> Julie Meloni --> [EMAIL PROTECTED] --> www.thickbook.com Find "Sams Teach Yourself MySQL in 24 Hours" at http://www.amazon.com/exec/obidos/ASIN/0672323494/thickbookcom-20 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
