I have a field `fedex`, in it is text date, in tab sep \n delimeted form, for example:
90 FedEx Home Delivery (Residential) 14.06 20 FedEx Express Saver 22.63 There can be x rows of data in the field, only every 3 "fields" to the data. So the above could be 5 lines in total, or one, whatever. Another field, `shipping_method` is what I am updating: Update orders set shipping_method = 20 where id = xxx So I know the shipping_method in advance, what I need to do, is get to the price data, and also update: Update orders set shipping_method = 20, price = x.xx where id = xxx Is there some way I can do some string parsing on the text field and get to the 3rd item where the passed in shippign_method equals? -- ------------------------------------------------------------- Scott Haneda Tel: 415.898.2602 <http://www.newgeo.com> Novato, CA U.S.A. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
