What is the AND operator?

+1 vote
Hi!!

Can someone tell me what is the AND operator?
Nov 30, 2018 in Database by DataKing99
• 8,130 points
62 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 Nov 30, 2018 by darklord
• 6,190 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 in Database by sampriti
• 1,100 points
98 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 in Database by anonymous
62 views
0 votes
1 answer

What is MSLAB and LZO?

MSLAB stands for Memstore-Local Allocation Buffer. Lempel-Ziv-Oberhumer (LZO) ...READ MORE

answered Jul 10, 2018 in Database by Data_Nerd
• 2,360 points
144 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,130 points
65 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 darklord
• 6,190 points
3,030 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 darklord
• 6,190 points
442 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 13, 2018 in Database by darklord
• 6,190 points
73 views
0 votes
1 answer

What is the EXISTS operator?

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

answered Dec 13, 2018 in Database by darklord
• 6,190 points
44 views