custom database query using php mysql -

i have build database , tables named news , articles.
have inserted 1000 words of article on table.

i'm able query article database shows full article on browser , want show articles 100 words "read more" button.
when read more button clicked full article shown page.

select substring(detail, 1, 100) articles 

assuming "detail" column in table "articles"