Query PHP variable against multiple MYSQL columns

Question

I have a php variable called industry, what i want to do is query that variable against the mysql database. However the mysql database has five columns in which that variable might be present, as indicated below.

industry ------> industry 1 industry 2 industry 3 industry 4 industry 5

below is my current php code.

     $query = "SELECT * FROM data where listing = 'rec' and industry='$industry'";

is there a way to query my php variable against all of the columns called industry?

Alexander Stumpf · Accepted Answer · 2015-02-16 22:00:03Z

1

I take your line "industry 1 industry 2 industry 3 industry 4 industry 5" means that there are five columns, named "industry1" through "industry5".

In this case you can combine the checks with an or operator.

SELECT * FROM data where listing = 'rec' and (industry1='$industry' or
  industry2='$industry' or industry3='$industry' or
  industry4='$industry' or industry5='$industry')

answered Feb 16, 2015 at 22:00

Alexander Stumpf

1164 bronze badges

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

Comments

Cameron · Accepted Answer · 2015-02-16 21:56:26Z

0

You're going to have to chain together the different possibilities in your WHERE clause.

SELECT *
FROM   DATA
WHERE  LISTING = 'REC'
       AND (    INDUSTRY_1 = '$INDUSTRY'
             OR INDUSTRY_2 = '$INDUSTRY'
             OR INDUSTRY_3 = '$INDUSTRY'
             OR INDUSTRY_4 = '$INDUSTRY'
             OR INDUSTRY_5 = '$INDUSTRY');

answered Feb 16, 2015 at 21:56

Cameron

2,60425 silver badges39 bronze badges

Collectives™ on Stack Overflow

Query PHP variable against multiple MYSQL columns

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related