Re: Displaying few words from record in mySQL [WORKS]
| From: | Rahul.Brenda | Date: | Sat, 08 Mar 2003 17:58:13 +0000 |
| Subject: | Re: Displaying few words from record in mySQL [WORKS] | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-138766@lists.php.net to get a copy of this message | ||
Chris..
2 words for you.. "WOW" and "WOW".
This works real well.. thanks. I didn't know it was
possible through an SQL statement.
Nik & Kevin, thanks a lot .. but this SQL Query works
too efficiently and fast.
Thanks again..
Rahul S. Johari
> Make mysql do the work for you.
>
> select substring_index(title, ' ', 20), author from
> news order by date desc
> limit 4
> // this particular string selects everything before
> the first 20 spaces of
> your title.
__________________________________________________
Do you Yahoo!?
Yahoo! Tax Center - forms, calculators, tips, more
http://taxes.yahoo.com/