MYSQL requires reading notes Chapter 6 Filtering data _ MySQL

This article will share with you the knowledge of filtering data in chapter 6 of MYSQL's required reading notes. it is very practical. I would like to share with you the website administrator platform for your reference. the code is as follows:

SELECT vend_id FROM products where vend_id <> 1003

Equivalent

The code is as follows:

SELECT vend_id FROM products where vend_id! = 1003

The code is as follows:

SELECT prod_name, prod_price FROM products WHERE prod_price BETWEEN 5 AND 10;

The code is as follows:

Select * from products
Where prod_price is Null;

The above is a small series to share with you the MYSQL will know the reading notes, chapter 6 of the filtering data content, I hope to help you!