Getting x characters from text

I have this SQL statement: SELECT ID, title, date, content FROM news ORDER BY date asc LIMIT 0,10 However, I only need the first 40 characters of the content field, which in some cases is over 5000 characters long. Is there a way to request only the first 40 characters of a field? Thanks in

Re: Getting x characters from text

At 19:48 +0300 10/4/05, Dotan Cohen wrote: I have this SQL statement: SELECT ID, title, date, content FROM news ORDER BY date asc LIMIT 0,10 However, I only need the first 40 characters of the content field, which in some cases is over 5000 characters long. Is there a way to request only the

RE: Getting x characters from text

:48 PM To: mysql@lists.mysql.com Subject: Getting x characters from text I have this SQL statement: SELECT ID, title, date, content FROM news ORDER BY date asc LIMIT 0,10 However, I only need the first 40 characters of the content field, which in some cases is over 5000 characters long