SQL statements: Two time interval segments, as long as there is a intersection, you can filter out

Set fixed time period: 8.2---"8.5

That is: two time periods, as long as the intersection can be filtered out:

The following two SQL statements achieve the same effect:

1: $sql = "SELECT * from Fs_ads where ' start_time ' <= ' $ed ' and ' end_time ' >= ' $sd '";

2:

$sql = "SELECT * FROM (
Select Ads_id,file_id,client_type,client_name,brand,model,cal_type Start_time,end_time,
Case
When (start_time>= ' $SD ') then start_time
When (start_time< ' $sd ') Then ' $SD '
End as Start1,
Case
When (end_time>= ' $ed ') Then ' $ed '
When (end_time< ' $ed ') then End_time
End as End1
From Fs_ads)
A Where a.start1<=a.end1;
"; Note: $SD, $ed is the time selected by the user reference: http://www.cnblogs.com/hupengyin/p/6051145.html

SQL statements: Two time interval segments, as long as there is a intersection, you can filter out