Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://www.geeksforgeeks.org/python/how-to-use-if-statement-in-mysql-using-python/ below:

How to Use IF Statement in MySQL Using Python

Last Updated : 23 Jul, 2025

Prerequisite: Python: MySQL Create Table

In this article, we are going to see how to use if statements in MySQL using Python. Python allows the integration of a wide range of database servers with applications. A database interface is required to access a database from Python. MySQL Connector-Python module is an API in python for communicating with a MySQL database. 

Approach:

• Import module.
• Make a connection request with the database.
• Create an object for the database cursor.
• Execute the following MySQL query:

IF(condition, value_if_true, value_if_false)

Example 1:

In this example we are using this database table with the following query;

Below is the implementation:

# Establish connection to MySQL database
import mysql.connector

db = mysql.connector.connect(
  host="localhost",
  user="root",
  password="root123",
  database = "geeks"
  )

#getting the cursor by cursor() method
mycursor = db.cursor()

insertQuery = " Select Value, IF(Value>1000,'MORE','LESS') from salary;"
mycursor.execute(insertQuery)
myresult = mycursor.fetchall()
print(myresult)

# close the Connection
db.close()

Output:

Example 2:

In this example we are using this database table with the following query;

Below is the full implementation:

# Establish connection to MySQL database
import mysql.connector

db = mysql.connector.connect(
  host="localhost",
  user="root",
  password="root123",
  database = "geeks"
  )

#getting the cursor by cursor() method
mycursor = db.cursor()

insertQuery = " Select City, IF(City = 'Patna','True','False') from persons;"
mycursor.execute(insertQuery)
myresult = mycursor.fetchall()

print(myresult)

# close the Connection
db.close()

Output:

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4