« previous next »
Pages: [1]

Author Topic: SELECT part of a field  (Read 878 times)

0 Members and 1 Guest are viewing this topic.

Offline trafficTopic starter

  • Irregular
  • Posts: 3
    • View Profile
SELECT part of a field
« on: November 17, 2005, 04:03:18 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...


...
Logged

Offline ryanlwh

  • Staff Alumni
  • Addict
  • *
  • Posts: 1,924
    • View Profile
SELECT part of a field
« Reply #1 on: November 17, 2005, 04:18:08 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--]
Logged
Please use EDIT * 100...
Please use
Code: [Select]
or [php] * 1000...

PLEASE READ THE POSTED SOLUTIONS CAREFULLY * 1000000...
Pages: [1]
« previous next »