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
976 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,370 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
1,119 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
1,066 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
664 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
908 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,370 points
12,632 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,370 points
2,032 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,370 points
754 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,370 points
443 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