How do I search a
I have a basic “property bag” table that stores attributes about michael michael kors handbags kors handbags my primary table “Card.” So when I want to start doing some advanced searching for cards, I can do something like this:What I need to do is to extract this idea into some kind of stored procedure, so that ideally I can pass in a list of property/value combi michael kors handbags nations and get the results of the search.
Initially this is going to be a “strict” search meaning that the results must match all elements in the query, but I’d also like to have a “loose” query michael kors handbags so that it would match any of the results in the query.
I can’t quite seem to wrap my head around this one. My previous version of this was to do generate some massive SQL query to execute with a lot of AND/OR clauses in it, but I’m hoping to do something a little more elegant this time. How do I go about doing this?