searching every occurrence of a term in a text field

Hi all having a table with one text field in which I store text (sic!) I need to extract from it every occurence of a term (or a phrase) with its context, litteraly extract 30 char before and 30 char after the term I have searched. thx for any suggestions ciao Mario -- MySQL General

searching every occurrence of a term in a text field

Hi all having a table with one text field in which I store text (sic!) I need to extract from it every occurence of a term (or a phrase) with its context, litteraly extract 30 char before and 30 char after the term I have searched. thx for any suggestions ciao Mario -- MySQL General Mailing