What is the AND operator

+1 vote
Hi!!

Can someone tell me what is the AND operator?
Dec 1, 2018 in Database by DataKing99
• 8,240 points
780 views

The AND operator is a Boolean operator used to perform a logical conjunction on two expressions -- 

Expression 1 And Experession 2. AND operator returns a value of TRUE if both its oprands are TRUE, and otherwise FALSE 

Hope you got your answer its very simple term on which we can perform multiple operation.

Thank you @psharma. It is a simple yet important operation.
Hello @psharma. Thanks for your explanation. Could you please post this as an answer? It would be much more visible and helpful then. Thank you.

1 answer to this question.

+1 vote

The AND operator is used to filter records that rely on more than one condition. This operator displays the records, which satisfy all the conditions separated by AND, and give the output TRUE.

Syntax:

SELECT column1, column2, ...
FROM table_name
WHERE condition1 AND condition2 AND condition3 ...;
answered Dec 1, 2018 by Sahiti
• 6,360 points

Related Questions In Database

0 votes
1 answer

Can you explain what is the difference between UNION and Join?

Hi Sahana,  I got your doubt, Checkout these ...READ MORE

answered May 30, 2019 in Database by sampriti
• 1,120 points
952 views
0 votes
1 answer

What is the rule to use group by, having and where clause?

Hi samar, this is a very common mistake ...READ MORE

answered Jul 2, 2019 in Database by anonymous
977 views
0 votes
1 answer

I have to build a school website How can i connect databases to the instance (ec2) and what is the best AMI for my webserver INAWS ???

Hi@Trinu, I don't think your database is depends ...READ MORE

answered May 4, 2020 in Database by MD
• 95,440 points
523 views
0 votes
1 answer

Why is not preferable to use mysql_* functions in PHP?

The reasons are as follows: The MySQL extension: Does ...READ MORE

answered Sep 7, 2018 in Database by DataKing99
• 8,240 points
725 views
0 votes
1 answer

Find values in a comma separated string in a MySQL query

You can add commas to the left and ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,360 points
12,468 views
0 votes
1 answer

How to do a batch insert in MySQL

You can try out the following query: INSERT ...READ MORE

answered Sep 10, 2018 in Database by Sahiti
• 6,360 points
1,911 views
0 votes
1 answer
0 votes
1 answer

What is the NOT Operator in MySQL?

NOT operator displays a record when the ...READ MORE

answered Dec 14, 2018 in Database by Sahiti
• 6,360 points
669 views
0 votes
1 answer

What is the EXISTS operator?

Exists operator is used to test if ...READ MORE

answered Dec 14, 2018 in Database by Sahiti
• 6,360 points
366 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP