Hi Guys,

Im pretty new to using MySQL within PHP and have come across a problem. I wondered if it is possible to limit the number of characters or words displayed from a result.

What I am trying to do is have a description which only displays the first say 50 words, the user can then click onto the item to view the full description!

I am just not sure of what SQL code I need to use!

I have tried searching the net, but the only results I get are to do with limiting the number of results returned, not limiting the length of the results themselves.

Any help would be greatly appreciated!