Search

1. Re: Is there a way to write custom queries directly in SQL?

   

   Comment by HartleySan · October 2017 · Home› The Database

   To provide a concrete example, I generated the following query from the query builder: SELECT * FROM Sets WHERE (NumericSetNumber >= 79100) AND (NumericSetNumber <= 79105 OR NumericSetNumber >= 79115) AND (NumericSetNumber <= 79122 OR NumericSetNumber >= 70800) AND (NumericSetNumber <= 70819) ORDER BY SortKey ASC However,…

2. Re: Is there a way to write custom queries directly in SQL?

   

   Comment by ricecake · October 2017 · Home› The Database

   @Paperballpark No, I think his query is correct. If he had ANDs instead of ORs, then it would return no results, because there is no NumericSetNumber that is simultaneously in all three ranges (79100-79105, 79115-79122, and 70800-70819). Therefore, he wants to return all sets that are in any of these ranges. So, it's…

3. Re: Is there a way to write custom queries directly in SQL?

   

   Comment by Paperballpark · October 2017 · Home› The Database

   I'm really not sure I understand what you're trying to search for. As far as I can see, you want to list the following: Sets 79100, 79101, 79102, 79103, 79104, 79105. OR Sets 79115, 79116, 79117, 79118, 79119, 79120, 79121, 79122. OR Sets 70800 through to 70819. The problem I see with this is that it's simply an odd query.…

4. Re: Is there a way to write custom queries directly in SQL?

   

   Comment by HartleySan · October 2017 · Home› The Database

   Paperballpark, I appreciate the response, but I don't think my query is that "odd". I'm simply trying to list out all the sets that I own so that when my daughters want to do one, instead of having to move all the boxes around on the shelves searching for which one they want to do, that can quickly look at a more visual…

Shopping at LEGO.com or Amazon?

Please use our links: LEGO.com • Amazon

Recent discussions • Categories • Privacy Policy • Brickset.com