Re: extracting substring from text blob during query

2004-07-26 Thread Egor Egorov
Redmond Militante [EMAIL PROTECTED] wrote: i have a large text blog that i want to extract strings out of.=20 the large text blob See http://dev.mysql.com/doc/mysql/en/String_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is

extracting substring from text blob during query

2004-07-21 Thread Redmond Militante
hi i have a large text blog that i want to extract strings out of. the large text blob looks like Name: john doe Date: 060604 Subject: this is subject Text: long text blob; i want to just extract 'john doe' '060604' and 'this is subject' from the text blob can i do this w mysql queries, or do