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.
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:
Execute the following query:
Next TopicMySQL OR Condition
JavaTpoint offers too many high quality services. Mail us on h[email protected], to get more information about given services.
JavaTpoint offers college campus training on Core Java, Advance Java, .Net, Android, Hadoop, PHP, Web Technology and Python. Please mail your requirement at [email protected].
Duration: 1 week to 2 week