Jump to content

query check for data on multiple ranges...


ajlisowski

Recommended Posts

Basically I want to write a query that checks to see if data exists in multiple ranges.

 

So lets say I have a numeric field "data". I want to write a query to see if a row exists with data >2 AND data between 2 and 1 AND data less then 1. I want to see if a row exists in all 3 of these ranges.

 

I could do 3 separate queries, or I could do 1 query with two UNIONs but is that any better? Is there any reason to union them over doing 1 query? Is there another option that I am missing?

Link to comment
https://forums.phpfreaks.com/topic/256539-query-check-for-data-on-multiple-ranges/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.