Take the 2-minute tour ×
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. It's 100% free, no registration required.

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

1 Answer 1

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

 
discard

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.