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
SELECT ID, title, date, left(content,40) FROM news ORDER BY date asc LIMIT
0,10
If you want the last 40, use right(), and if you want to choose a section,
use the mid() function.
HTH,
J.R.
-Original Message-
From: Dotan Cohen [mailto:[EMAIL PROTECTED]
Sent: Tuesday, October 04, 2005