fetch data from mysql table using php ignoring some values?

Question

I have a table which have a column with name domain_name. in domain_name column, different values stores like google.com, facebook.com, twitter.com etc. I try this which is working.

$query= 'Select * from accountdb WHERE domain_name="twitter.com" order by domain_name ASC';

But I want to pick that rows which have the values facebook.com, twitter.com in one query. I try this to achieve but not working.

$query= 'Select * from accountdb WHERE domain_name="twitter.com" and domain_name="facebook.com" order by domain_name ASC';

Alterring quotes

$query= "Select * from accountdb WHERE domain_name='twitter.com' and name='facebook.com' order by domain_name ASC";

Any hint would be appreciated.

either use or or an in clause (select * from accountdb where domain_name in 'twitter.com', 'facebook.com') — Federico klez Culloca
– Federico klez Culloca, Commented Oct 26, 2018 at 15:25

Sailesh Babu Doppalapudi · Accepted Answer · 2018-10-26 15:29:28Z

1

And means that both conditions have to be met which will never ever happen. You want domain_name to be either "twitter.com" or "facebook.com". So you have to use or

$query= 'Select * from accountdb WHERE domain_name="twitter.com" or domain_name="facebook.com" order by domain_name ASC';

If you have more than 2 domains to check, best way is to use in.

$query= 'Select * from accountdb WHERE domain_name in ("twitter.com","facebook.com","google.com") order by domain_name ASC';

answered Oct 26, 2018 at 15:29

Sailesh Babu Doppalapudi

1,5561 gold badge10 silver badges24 bronze badges

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

4 Comments

user8850199 Over a year ago

If I want to ignore these these three results query may be?

$query= 'Select * from accountdb WHERE domain_name!="twitter.com" and domain_name!="facebook.com" and domain_name!="google.com" order by domain_name ASC';

Sailesh Babu Doppalapudi Over a year ago

Yes. Or you can use not in.

$query= 'Select * from accountdb WHERE domain_name not in ("twitter.com","facebook.com","google.com") order by domain_name ASC';

Bhushan Over a year ago

Select * from accountdb WHERE domain_name NOT IN ("twitter.com","facebook.com") ORDER BY domain_name ASC;

Sailesh Babu Doppalapudi Over a year ago

@faisal97 Please mark it as answer if this solves your problem.

e_i_pi · Accepted Answer · 2018-11-11 07:46:48Z

0

You can use OR:

$query= 'Select * from accountdb WHERE domain_name="twitter.com" OR domain_name="facebook.com" order by domain_name ASC';

edited Nov 11, 2018 at 7:46

e_i_pi

4,8605 gold badges32 silver badges47 bronze badges

answered Oct 26, 2018 at 15:28

Bhushan

464 bronze badges

Collectives™ on Stack Overflow

fetch data from mysql table using php ignoring some values?

2 Answers 2

4 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related