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/[EMAIL PROTECTED]