List:General Discussion« Previous MessageNext Message »
From:J.R. Bullington Date:October 4 2005 4:54pm
Subject:RE: Getting x characters from text
View as plain text  
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:dotancohen@stripped] 
Sent: Tuesday, October 04, 2005 12:48 PM
To: mysql@stripped
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. Is there a way to request only the
first 40 characters of a field? Thanks in advance.

Dotan Cohen
http://www.technology-sleuth.com/mobile/cellphones.php

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=1


Attachment: [application/x-pkcs7-signature] smime.p7s
Attachment: [application/x-pkcs7-signature] smime.p7s
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