MySQL 'or' statement with multiple values

Question

when building the query in mySQL, How do I fetch the result with multiple values

Example code:

if (strtolower($_REQUEST['shirt_color']) == 'showall' && (isset($_REQUEST['shirt_type']))
        {
            $params[] = array('field' => 'color_type',
                       'operator' => '=',
                      'value' => 'black'
                              );
        }

The above pice of code works fine and gets the correct results, However I want to search for two different colors:

I tried putting --- 'value' => "'black' OR 'white'" but it doesnt work.

You should show us how these params are processed by script generating sql query. One thing that comes to my mind is setting an operator to IN and value to ('black', 'white') — Przemysław Jan Wróbel
– Przemysław Jan Wróbel, Commented Aug 5, 2015 at 6:03

Zim84 · Accepted Answer · 2015-08-05 06:19:49Z

2

Try the IN operator. Something like that shall be your resulting query:

SELECT * FROM tshirts WHERE color IN ('black','white');

If you provide us with the code you have to generate the query string, we could help you with adapting it to the IN operator.

answered Aug 5, 2015 at 6:19

Zim84

3,5672 gold badges39 silver badges42 bronze badges

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

Comments

Elyor · Accepted Answer · 2015-08-05 06:25:20Z

1

Try using something like

Select * from tshirts where color = 'black' OR color = 'white'

edited Aug 5, 2015 at 6:25

answered Aug 5, 2015 at 6:13

Elyor

5,59210 gold badges55 silver badges78 bronze badges

1 Comment

Toby D Over a year ago

Should there be only unique key for dictionary, I believe?

Collectives™ on Stack Overflow

MySQL 'or' statement with multiple values

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related