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 12:
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 fir
