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

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

newbie question about sp

I'm trying to call this simple store procedure on my XP with "mysql Ver 14.3 Distrib 5.0.0-alpha, for Win95/Win98 (i32)", server is 5.0.0-alpha-max-debug-log: CREATE PROCEDURE test_repeat () BEGIN SET @x = 1000; REPEAT SET @x = @x + 1; UNTIL @x < 10 EN