Jump to content


Photo

SELECT part of a field


  • Please log in to reply
1 reply to this topic

#1 traffic

traffic
  • New Members
  • Pip
  • Newbie
  • 1 posts

Posted 17 November 2005 - 09:03 PM

Hello...

I have a field in my database that is a 'text' field - post_text...

I want to be able to select just the first (500) characters in the field - but, can't seem to find any documentation for this...

Any help would be appreciated...


...

#2 ryanlwh

ryanlwh
  • Staff Alumni
  • Advanced Member
  • 511 posts

Posted 17 November 2005 - 09:18 PM

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] LEFT(post_text,500) AS excerpt FROM... [!--sql2--][/div][!--sql3--]
Please use EDIT * 100...
Please use
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users