Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

retrieving 'teaser' from table

Status
Not open for further replies.

jnxx

Programmer
May 18, 2005
14
GB
I'm writing a cms where i just want to retrieve a few lines of words from a article posted in a mysql table, sort of like a teaser.

Does any one know how this can be done? OR perhaps point me in the right direction?
Thanks
 
something like:

select substring(your_field,0,300) will return the first 300 characters of the given field.

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top