MYSQL Using AND and Wildcard

Question

SQL statement is:

SELECT * 
FROM cigardata 
WHERE Brand LIKE '$brandS' 
  AND Style LIKE '$styleS' 
  AND Wrapper LIKE '$wrapperS' 
  AND UPC LIKE '$upcS';

User inputs Brand and Wrapper only and it will return nothing, normal since nothing in the other 2 fields. If I fill all 4 fields of course it works perfect. What can be used in the other 2 fields as a wild card to satisfy that all 4 fields are filled and return a result? I have tried %.%, %''%, %*%. Any suggestions......

just don't add AND field like "$field" for non defined ones? — Flash Thunder
– Flash Thunder, Commented Feb 19, 2019 at 16:23
For matching anything, you can use just a single '%'. But the first comment is a better solution to your specific problem. — Rob Streeting
– Rob Streeting, Commented Feb 19, 2019 at 16:30
the program should build the query dynamically based on the user input. — isaace
– isaace, Commented Feb 19, 2019 at 16:32
So if you have "user inputs", where are they? What kind of application is this? We need more information before we can help you. There are various ways to solve this, but we need more information. — artemis
– artemis, Commented Feb 19, 2019 at 16:41
It is a combination of HTML and PHP. User inputs are via a text box in the HTML part and then in the PHP part: $brandS=$_POST["brandS"]; Also there are precautions take to prevent SQL Injection. — Blue68Camaro
– Blue68Camaro, Commented Feb 19, 2019 at 18:29

Blue68Camaro · Accepted Answer · 2019-03-06 23:06:56Z

0

isaace answer was the clue, the word "dynamically" led me to a solution that has been answered previously. Had to tweek it a bit with single quotes on the {$field1} to '{$field1}' and so on with the field 2 field 3 etc. Crating a Dynamic Search

answered Mar 6, 2019 at 23:06

Blue68Camaro

1132 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MYSQL Using AND and Wildcard

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related