php - MySQL Fulltext search results in html content -

i have database oages of content. content in html format. want make content searchable figured fulltext search best. have query setup below:

select * pages match(content) against ('search'); 

that gives me list of pages, however, there multiple matches on pages. want pull out matches of content surrounding show little snippets of results on search results page.

i using php running query.

you use clause simple string matching, along lines of:

select content pages content '%keyword%';