traffic Posted November 17, 2005 Share Posted November 17, 2005 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... ... Link to comment https://forums.phpfreaks.com/topic/2888-select-part-of-a-field/ Share on other sites More sharing options...
ryanlwh Posted November 17, 2005 Share Posted November 17, 2005 [!--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--] Link to comment https://forums.phpfreaks.com/topic/2888-select-part-of-a-field/#findComment-9715 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.