[RESOLVED] MySQL Partial Selection of a Field

[NFClimber]

I've spent the last few hours putting together an RSS generator for my company's web site. Basically what happens, is when someone submits a story, PHP exports a some formatted code into an XML file. Right now, I have the user create a description of their entry. What I would like to do, is simply select the first 10 words or so from their entry and use that as a description in my XML file. Is there any way, whether it be in my SELECT statement or otherwise, that I can make this happen? Any best practice ideas?

Thanks in advance...

[thorpe]

SELECT SUBSTRING(fld,0,40) AS abstract FROM tbl;

Would return the first 40 chars from the field fld.

[NFClimber]

Thanks!

[NFClimber]

Thanks for the help, but just as an FYI, it has to be SUBSTRING(fld,1,40) to select from the beginning of the field, (0,40) will return empty values and cause errors.