MySQL AND Comparison Functions and Operators By Example

MySQL AND

MySQL logical AND operator compares two expressions as well as this is a returns bollean data like as a true if both of the expressions are true.

Comparison Functions and Operators – MySQL

mysql tutorial, if, like, contains, comparison, operators, bitwise operators and between.

TRUE FALSE NULL
TRUE TRUE FALSE NULL
FALSE FALSE FALSE FALSE
NULL NULL FALSE NULL
Read Also:  laravel middleware check custom header for REST API

set operators in sql

MySQL AND operator examples

SELECT 
    membername, 
    place, 
    location
FROM
    members
WHERE
    place = 'INDIA' AND location = 'GJ';

Example :

SELECT    
	membername, 
	place, 
	location, 
	creditlimit
FROM    
	members
WHERE place = 'INDIA'
	AND location = 'GJ'
	AND creditlimit > 100000;

I hope you get an idea about WHERE, AND, OR, IN, NOT IN.
I would like to have feedback on my infinityknow.com blog.
Your valuable feedback, question, or comments about this article are always welcome.
If you enjoyed and liked this post, don’t forget to share.

Read Also:  Laravel Email Verification Script Example

About Pakainfo

I am Jaydeep Gondaliya, a software engineer, the founder and the person running Pakainfo. I'm a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, Javascript, JQuery, Laravel, Codeigniter, VueJS, AngularJS and Bootstrap from the early stage.

View all posts by Pakainfo →

Leave a Reply

Your email address will not be published. Required fields are marked *