Javatpoint Logo
Javatpoint Logo

MySQL AND Condition

The MySQL AND condition is used with SELECT, INSERT, UPDATE or DELETE statements to test two or more conditions in an individual query.


Parameter explanation:

condition1, condition2, ... condition_n: Specifies all conditions that must be fulfilled for the records to be selected.

MySQL AND Example

The following example specifies how to use the AND condition in MySQL with SELECT statement.

Consider a table "cus_tbl", having the following data:

MySQL AND Condition 1

Execute the following query:


MySQL AND Condition 2
Next TopicMySQL OR Condition

Youtube For Videos Join Our Youtube Channel: Join Now


Help Others, Please Share

facebook twitter pinterest

Learn Latest Tutorials


Trending Technologies

B.Tech / MCA