MySQL Forums
Forum List  »  Stored Procedures

Re: How to split delimited column and query other table using the split value.
Posted by: Peter Brawley
Date: May 10, 2015 02:29PM

OK, MySQL functions can't return multi-value objects like rows or tables, so your best bet might be an sproc that invokes substring_index() on the bastardised column in a loop to populate a named child table which the caller can then query.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to split delimited column and query other table using the split value.
1170
May 10, 2015 02:29PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.