List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 4 2005 4:51pm
Subject:Re: Getting x characters from text
View as plain 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 first 40 characters of a field? Thanks in advance.

LEFT(str,len) ?

http://dev.mysql.com/doc/mysql/en/string-functions.html

-- 
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Thread
Getting x characters from textDotan Cohen4 Oct
  • Re: Getting x characters from textPaul DuBois4 Oct
  • RE: Getting x characters from textJ.R. Bullington4 Oct