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 i have to use regular expressions in php or perl to get substrings out after the query? thanks redmond -- Redmond Militante Software Engineer / Medill School of Journalism FreeBSD 5.2.1-RELEASE-p9 #0: Thu Jul 1 14:36:26 CDT 2004 i386 7:30PM up 5 days, 1:34, 2 users, load averages: 0.04, 0.03, 0.01
pgptXWBhHwSr9.pgp
Description: PGP signature