Re: Need help with creating a "look-up" table in MySQL
Posted by: Chris Bassett
Date: September 06, 2013 12:19PM

OK, but this may need to be done once, or done 100 times, depending on the number of custom fields that apply to the product....

Are there any complete examples with source that would maybe give some idea as to how this may work?

I get the idea of what you are suggesting, I'm just trying to apply it where this process can be repeated on the same column, but work its way through the custom fields for a particular device.

So, le'ts say that we first find all rows where custom field #1 = 1. Then we need to go through the table again and find all rows where custom field #1 = 1 AND custom field #2 = 1, and so on. But we want to serach the results found in the first query as results to search for the second query, essentially drilling down as far as we can go until we have searched all custom fields for appropriate matches. Each query will narrow down the results further than the previous query basically.

Options: ReplyQuote




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.