SQL select query - selecting from different fields

Question

I have a MySQL table with the following columns: location, title and date.

I would like to search for the following

location = San Francisco OR Los Angeles
And
title = Hadoop OR Teradata
And
date = 21-5-2017 or 20-5-2017

Is that possible to do in one SQL query?

Thanks

Did you try writing the query same way? Did it work? Any error? — Chetan
– Chetan, Commented May 25, 2017 at 5:37
Are you really storing your dates as text (21-5-2017)? Don't do that, use a date column type. — Tim Biegeleisen
– Tim Biegeleisen, Commented May 25, 2017 at 5:43

Ullas · Accepted Answer · 2017-05-25 05:37:58Z

3

Query

select * from `your_table_name`
where (`location` = 'San Francisco' or `location` = 'Los Angeles')
and (`title` = 'Hadoop' or `title` = 'Teradata')
and (`date` = '21-5-2017' or `date` = '20-5-2017');

answered May 25, 2017 at 5:37

Ullas

11.6k5 gold badges36 silver badges52 bronze badges

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

1 Comment

Ullas Over a year ago

@LironToval : Please mark it as answer if it solved your problem.

Strawberry · Accepted Answer · 2017-05-25 06:33:45Z

0

Or, perhaps more elegantly...

select *
  from your_table_name
 where location IN ('San Francisco','Los Angeles')
   and title IN('Hadoop', 'Teradata')
   and date IN('2017-05-21', '2017-05-20');

answered May 25, 2017 at 6:33

Strawberry

34k14 gold badges43 silver badges57 bronze badges

Collectives™ on Stack Overflow

SQL select query - selecting from different fields

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related