Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I need to perform several queries, looking for more than one parameter.

for example: in my field "lenght" I want to extract values matching both 4.6 and 4.7. then, next time I need 5.8 and 5.9, and so on. I will be searching for more parameters.

Is it possible to create an input form where i can input something like:

4.6 AND 4.7 

PS: would it be better to use a different database software?

share|improve this question

If you'll input "4.6, 4.7", it could construct sql-query, using IN predicate that will give you something like:

where length IN(4.6, 4.7)
share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.