Hi can someone tell me how to create an sql statement in which I can include multiple conditions?

e.g. I want to select all from a particular table in which I can enter different keywords that would produce different results such as all items by a particular brand e.g. microsoft or all items in a particular category business applications or in a product group software.

Thanking you in advance for taking the time to answer my question.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.