MySQL Forums
Forum List  »  General

Re: Compressing (and indicating) multiple rows
Posted by: Andrew Simkovsky
Date: August 26, 2013 12:23PM

It's possible with some fancy queries or stored procedures, but almost not worth it. Anything you do there would probably end up being more complicated than just joining the two tables together, and having the application code parse the result set and write the application code itself to display the wildcard for multiple tasks.

If you MUST do it at the SQL level, I foresee a subquery in the FROM clause. Not that its bad, but it can be a pain, especially when your focus is on application functionality, rather than writing complex queries. Like I said, probably not worth the headache.

Andrew Simkovsky
More mysql forums (and other databases):
http://www.dbtekpro.com/forums
Brand new! Just post!

Options: ReplyQuote


Subject
Written By
Posted
Re: Compressing (and indicating) multiple rows
August 26, 2013 12:23PM


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.