Скачать или смотреть How To: Between Operator In MySQL (2 Min)

In this tutorial, you'll learn how to use the Between and NOT Between operator in the mysql database.

—
Facebook:   / gokcedbsql  
—
Video Transcript:
—
Connect MySQL In Python:    • How To Connect To MySQL In Python (2 Min) ...  
—
Hi guys, this is Abhi from Gokcedb. In this video, you're going to learn how to use the between keyword in my MySQL database. Let's start by looking at the entity relationship diagram.

I have 15 tables in my database right now but in this tutorial, we'll mostly be running queries on the property and the property underscore status. Say I wanted to count the number of records in my property table where the property d date was recorded. The date is greater than or equal to Jan 1st, 2018, and less than equal to December 31st, 2048.

To do that, I can make use of the greater than equal to and less than equal to the operator in the where clause. However, a faster way to write the same query is to use the between keyword. Note both the date values are included in this query.

Now say I wanted to count all the records in the property table where the property d date recorded date is less than Jan 1st, 2018, or greater than December 31st, 2018. To do that, I'll use the or operator in the where clause. However, a faster way to write the same query is by using the not-between keyword in conjunction with the end operator.

Let's look at a little bit more complicated example. This time I want to select the property number property county and property status name for all the properties where the deed was recorded in the year 2018. To do that, I'll write an inner join between the property table and the property underscore status table.

On property dot property underscore status underscores id. In the where clause, I'll use the between keyword to specify the start date of January 1, 2018, and the end date of December 31st, 2018. To sort the output in the descending order of property numbers.

Use the order by clause with the desc keyword. There you have it. Make sure you like, subscribe, and turn on the notification bell.

Until next time.

SELECT property.property_number, property.property_county, property_status.property_status_name FROM property INNER JOIN property_status ON property.property_status_id = property_status.id WHERE property.property_deed_date_recorded BETWEEN '2018-01-01' AND '2018-12-31' ORDER BY property_number DESC;