SQL multiple OR chain query

Question

I have a single table where I am attempting to access rows via a simple SQL query I think, however, I am misunderstanding the way the OR modifier technically works. The statement I am trying to query is as follows:

SELECT * from table WHERE name OR vehicle OR state OR address LIKE '%input term here%';

This either returns an empty table, or in some instances the entire table. If I pare down the statement to include 0 OR modifiers it works, the trouble begins when I attempt to chain them like above. I'm looking for the simplest way to have one single query for the table, I think this might not be possible the way I'm going about it though. Any ideas?

NOTE: I am sanitizing input, I changed the end of the query for readability.

You need to add LIKE '%input term here%' for every column you want to apply it to. — jeroen
– jeroen, Commented Jan 6, 2017 at 9:45

Tim Biegeleisen · Accepted Answer · 2017-01-06 09:46:18Z

4

You need to repeat the LIKE expression for each column, i.e.

SELECT *
FROM yourTable
WHERE name    LIKE '%input term here%' OR
      vehicle LIKE '%input term here%' OR
      state   LIKE '%input term here%' OR
      address LIKE '%input term here%'

answered Jan 6, 2017 at 9:46

Tim Biegeleisen

526k32 gold badges323 silver badges399 bronze badges

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

Comments

JohnHC · Accepted Answer · 2017-01-06 09:51:09Z

3

SELECT * from table 
WHERE name LIKE '%input term here%' 
OR vehicle LIKE '%input term here%' 
OR state LIKE '%input term here%' 
OR address LIKE '%input term here%';

try this out

edited Jan 6, 2017 at 9:51

JohnHC

11.2k1 gold badge28 silver badges42 bronze badges

answered Jan 6, 2017 at 9:46

smn_onrocks

1,3421 gold badge19 silver badges34 bronze badges

Collectives™ on Stack Overflow

SQL multiple OR chain query

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