1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Rep Power
    I want to make a quick preview option on my front page where i return the article title and then say 200 letters from the body of the text.

    Is there an way to select say only 200 chars of the text field rather than return the whole thing and discard most of it?
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Niagara Falls (On the wrong side of the gorge)
    Rep Power
    mysql does have a substring function. You'll have to check the manual, I don't have the parameters in hand.

Similar Threads

  1. Search a field for part of something?
    By Jhorra in forum MS SQL Development
    Replies: 1
    Last Post: February 16th, 2004, 08:53 AM
  2. Wan to select partial text in a text field
    By raghava66 in forum HTML Programming
    Replies: 2
    Last Post: February 12th, 2004, 02:11 AM
  3. html form problem using mult select and file field
    By Justin_M in forum HTML Programming
    Replies: 4
    Last Post: January 5th, 2004, 07:13 PM
  4. tell me how to select first char from a field
    By hasitha in forum PHP Development
    Replies: 3
    Last Post: December 24th, 2003, 02:48 AM
  5. Replies: 1
    Last Post: December 16th, 2003, 03:03 AM

IMN logo majestic logo threadwatch logo seochat tools logo