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... ... Quote 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--] Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.