select value from multiple columns mysql

Question

On my site a user enters an account number and I have a script to show the business name belonging to that account number, however the account number could be in 2 columns.

I have the below code to search 1 of the columns (personID);

sql="SELECT * FROM member WHERE personID = '".$q."'";

How do I edit this code to search 2 columns (personID & another column) for the account number?

WHERE personId = 'something' OR other_column = 'something' — raina77ow
– raina77ow, Commented Jun 29, 2014 at 14:36

James Walker · Accepted Answer · 2014-06-29 14:37:47Z

1

I believe the SQL OR is what you're looking for. Might be worth taking a look here http://www.w3schools.com/sql/sql_and_or.asp

sql="SELECT * FROM member WHERE personID = '".$q."' OR othercolumn = '".$q."'";

answered Jun 29, 2014 at 14:37

James Walker

7952 gold badges7 silver badges23 bronze badges

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

Comments

no_juan · Accepted Answer · 2014-06-29 14:40:44Z

0

Use OR:

sql="SELECT * FROM member WHERE personID = '".$q."' OR anotherColumn = '".$q."'";

answered Jun 29, 2014 at 14:40

no_juan

673 bronze badges

Comments

Gordon Linoff · Accepted Answer · 2014-06-29 14:42:51Z

0

You can do this with in:

sql="SELECT * FROM member WHERE '".$q."' IN (personID, othercol)"

The advantage of in is that the parameter is only mentioned once. This makes it easier to use proper parameters rather than string substitution -- a much better approach to generating SQL.

answered Jun 29, 2014 at 14:42

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

Collectives™ on Stack Overflow

select value from multiple columns mysql

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related