[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    Newbie help: extracting pattern based data from fields
From:       Ravi Malghan <rmalghan () yahoo ! com>
Date:       2006-02-27 20:01:40
Message-ID: 20060227200140.58879.qmail () web53006 ! mail ! yahoo ! com
[Download RAW message or body]

Hi: My database is mysql 4.1.14-standard. I have a
blob type field in a table1 with mutlple attributes
together in the field as shown below
table1.field1 value for a record is "abc=2 def=4
ghi=10"

I have table2 which has fields abc, def and ghi. I
want to be able to parse the table1.field1 and insert
values 2 for table2.abc, 4 for table2.def and 10 for
table2.ghi.

1. Is stored procedure the only way to do this?
2. 4.x does not support stored procedures. If this is
correct, is there any other way to accomplish this?
3. how do I extract values from a field based on a
pattern? Just looking for some pointers to get started
on this.

Thanks
Ravi

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]