MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: Find number between 1-10 in data
Posted by: Rick James
Date: June 03, 2014 10:46PM

Don't say "1-10" in a single column; have two columns. Then the WHERE clause can be something like this to see two ranges overlap:

WHERE a.start < b.end AND a.end > b.start

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
Find number between 1-10 in data
John Walpole
June 03, 2014 06:35PM
Re: Find number between 1-10 in data
Peter Brawley
June 03, 2014 09:18PM
Re: Find number between 1-10 in data
John Walpole
June 03, 2014 09:43PM
Re: Find number between 1-10 in data
Rick James
June 03, 2014 10:46PM
Re: Find number between 1-10 in data
Peter Brawley
June 04, 2014 08:17AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.