ajlisowski Posted February 6, 2012 Share Posted February 6, 2012 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 More sharing options...
fenway Posted February 6, 2012 Share Posted February 6, 2012 Benchmark it. Link to comment https://forums.phpfreaks.com/topic/256539-query-check-for-data-on-multiple-ranges/#findComment-1315131 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.