Skip to content

Python MySQL - LIKE() operator

Python MySQL - BETWEEN and IN Operator

Last Updated : 29 Jul, 2021

In this article, we are going to see the database operations BETWEEN and IN operators in MySQL using Python.

Both of these operators are used with the WHERE query to check if an expression is within a range or in a list of values in SQL. We are going to use the below table to perform various operations:

The SQL BETWEEN condition is used to test if an expression is within a range of values (inclusive). The values include text, date, or numbers.

It can be used along with the SELECT, INSERT, UPDATE, or DELETE statement.
The SQL BETWEEN Condition will return the records where the expression is within the range of value1 and value2.

Syntax:

SELECT column1,column2,....,column n

FROM table_name

WHERE column_name BETWEEN value1 AND value2;

Example 1: Python MySQL program to demonstrate the use of BETWEEN operator.

Python3

# Import mysql.connector module import mysql.connector  # give connection with xampp database = mysql.connector.connect(     host="localhost",     user="root",     password="",     database="gfg" )  # Creating cursor object cur_object = database.cursor() print("between operator demo")  #  query find = "SELECT cus_id,purchase from geeks where\ purchase between 10 and 100 "  # Execute the query cur_object.execute(find)  # fetching results data = cur_object.fetchall() print(" ") print("Purchase between 10 to 100 ") print(" ")  for res in data:     print(res[0], res[1], sep="--") print(" ")  # Close database connection database.close()

Output:

The SQL IN operator allows you to easily test if the expression matches any value in the list of values. It is used to remove the need for multiple OR conditions in SELECT, INSERT, UPDATE or DELETE. You can also use NOT IN to exclude the rows in your list.

Syntax:

SELECT column1,column2,...,column n

FROM tablename

WHERE column IN (val1,val2,...,valn);

Example 2: Python MySQL program to demonstrate the use of IN operator.

Python3

# Import mysql.connector module import mysql.connector  # give connection with xampp database = mysql.connector.connect(     host="localhost",     user="root",     password="",     database="gfg" )  # Creating cursor object cur_object = database.cursor()  #  query print("in operator demo") find = "SELECT cus_id,purchase from geeks where \ purchase in (67) "  # Execute the query cur_object.execute(find)  # fetching all results data = cur_object.fetchall() print("customer id with purchase 67: ") print(" ")  for res in data:     print(res[0], res[1], sep="--") print(" ") print("not in operator demo") print(" ")  find = "SELECT cus_id,purchase from geeks where purchase\ not in (67) "  # Execute the query cur_object.execute(find)  # fetching all results data = cur_object.fetchall() print(" ") print("customer id with purchase except 67 purchase ") print(" ")  for res in data:     print(res[0], res[1], sep="--")  # Close database connection database.close()

Output:

Python MySQL - LIKE() operator

sravankumar_171fa07058

Improve

Article Tags :

Practice Tags :

python

Similar Reads

Python MySQL - LIKE() operator

In this article, we will discuss the use of LIKE operator in MySQL using Python language. Sometimes we may require tuples from the database which match certain patterns. For example, we may wish to retrieve all columns where the tuples start with the letter â€˜yâ€™, or start with â€˜bâ€™ and end with â€˜lâ€™, o

Python Bitwise Operators

Python bitwise operators are used to perform bitwise calculations on integers. The integers are first converted into binary and then operations are performed on each bit or corresponding pair of bits, hence the name bitwise operators. The result is then returned in decimal format. Note: Python bitwi

Python Membership and Identity Operators

There is a large set of Python operators that can be used on different datatypes. Sometimes we need to know if a value belongs to a particular set. This can be done by using the Membership and Identity Operators. In this article, we will learn about Python Membership and Identity Operators. Python M

Comparison Operators in Python

Python operators can be used with various data types, including numbers, strings, boolean and more. In Python, comparison operators are used to compare the values of two operands (elements being compared). When comparing strings, the comparison is based on the alphabetical order of their characters

PostgreSQL - NOT BETWEEN operator

PostgreSQL NOT BETWEEN operator is used to match all values against a range of values excluding the values in the mentioned range itself. Syntax: value NOT BETWEEN low AND high; Or, Syntax: value high; The NOT BETWEEN operator is used generally with WHERE clause with association with SELECT, INSERT,

Chaining comparison operators in Python

Checking multiple conditions in a single expression is common in programming. In Python, comparison operator chaining allows us to write cleaner, more readable code when evaluating multiple conditions. Instead of using multiple and conditions, Python enables chaining comparisons directly in a mathem

Python 3 - Logical Operators

Logical Operators are used to perform certain logical operations on values and variables. These are the special reserved keywords that carry out some logical computations. The value the operator operates on is known as Operand. In Python, they are used on conditional statements (either True or False

PostgreSQL - BETWEEN Operator

The PostgreSQL BETWEEN operator is an essential tool for filtering data within a specific range. Often used in the WHERE clause of SELECT, INSERT, UPDATE, and DELETE statements, this operator simplifies range-based conditions, making queries faster and easier to read. In this article, we will explai

Python Logical Operators

Python logical operators are used to combine conditional statements, allowing you to perform operations based on multiple conditions. These Python operators, alongside arithmetic operators, are special symbols used to carry out computations on values and variables. In this article, we will discuss l

Python MySQL - GROUP BY and HAVING Clause

In this article, we will see how to perform groupby() and HAVING() operations on SQL using Python. Here we will consider a college database to perform group by operation on the department with respect to student strength. GROUP BY The GROUP BY statement groups rows that have the same values into sin