First 250 words in field.....

[grudz]

Hi,

I was just wondering if there's some sort of WHERE clause that can say, show me the first 250 words in this field (i'm gonna have a very long text)....??

Thank you

[sad69]

Is this a PHP question or a MySQL question...?

I'm gonna say MySQL, so it should probably be moved over there, but anyway:
http://www.bitmechanic.com/mail-archives/mysql/current/0848.html
http://www.ispirer.com/doc/sqlways37/Output/SQLWays-1-060.html

Those references should answer your question.

Hope that helps,
Sadiq.

[grudz]

ur right...im sorry....ill be carefull next time

[raf]

check your mysql-thread (for 200 characters)