Between and Not Between operator in MySql

Between and Not Between operator in MySql

SUMMARY

In this video we will learn about Between and Not Between operator in MySql.

DEFINITION OF BETWEEN AND NOT BETWEEN OPERATOR

Between operator is used to fetch all records within the provided range.Not Between is the opposite to between operator. Not Between operator is used to fetch all records outside the provided range.

PREREQUISITE

In the above video first we login our mysql server . Then check all database list and select our preferred database.you select your database as per your requirement. In our case we select techrideradmin database . Then select the table list within the database. In our case we select department table. Now fetch all records form the table.

EXAMPLE OF BETWEEN AND NOT BETWEEN OPERATOR

We have two queries for between and not between operator . These are given below.

1) Now we want to use between operator to fetch the records within the salary range 20000 to 25000. It will fetch all the records within this range.

2) Now we want to use not between operator to fetch the records outside the salary range 20000 to 25000. It will fetch all the records outside this range.

CONCLUSION

In this above video we have learned about between and not between operator in mysql.

Thanks for watching.Visit Website : techrideradmin.blogspot.com