Scott Haneda wrote:
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
(...)
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?
You can do something with a combination of the functions SUBSTRING(),
LOCATE() and SUBSTRING_INDEX(), but it would of course be a lot wiser
extract the information from this field and put it in a table of some
sort. That way it would be a lot faster to find the data (no need to
parse every single record) and you wouldn't need to write complex
expressions to find the data you want...
Regards, Jigal.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]