List:General Discussion« Previous MessageNext Message »
From:Dotan Cohen Date:October 4 2005 4:48pm
Subject:Getting x characters from text
View as plain 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 advance.

Dotan Cohen
Getting x characters from textDotan Cohen4 Oct
  • Re: Getting x characters from textPaul DuBois4 Oct
  • RE: Getting x characters from textJ.R. Bullington4 Oct