devxlogo

WHERE (multiple values)

WHERE (multiple values)

Question:
I have a form in which the user can select multiple values of “Manufacturer” from a drop-down list.

The query should then select from the database all records in which Manufacturer matches one of those listed. It works fine when a single manufacturer is selected, but what syntax do I use to match multiple Manufacturers?

Answer:
Using the IN predicate in your WHERE clause will match the records:

…WHERE manufacturer IN (selection_list);
The exact syntax will depend on your database product — you may be able tospecify variable names to make the statement more portable. Check yourdocumentation for the details.

See also  Digital Signage Solutions for Agile Software Development Teams
devxblackblue

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

About Our Journalist