MySQL Forums
Forum List  »  Newbie

Selected Values between multiple ranges
Posted by: Ebrahim Hassania
Date: October 28, 2009 05:43AM

Hi all,

I cant figure this part of my query. I want my query to select values between two sets of ranges. Anything with a product id under 66 (0-65) and also any product id between 115-127 (116-126)

MYSQL query..
AND (vista_license.product_id < 66 AND vista_license.product_id BETWEEN 115 AND 127)
Order by vista_account.full_name;

Options: ReplyQuote

Written By
Selected Values between multiple ranges
October 28, 2009 05:43AM

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.