Python SQL Where Clause

In this article, we will show you, How to write a SQL Where in the Python Programming language and how to filter the Table records with an example. 

TIP: Please refer Connect Python to SQL Server article to understand the steps involved in establishing a connection.

Before we get into the Python SQL Where example, let me show you the data that we are going to use.

Python SQL Where Clause Example 1

In this example, we will show you, how to use the Where Clause to filter the Data or restrict the records based on condition.

# Python SQL Where Example
import pyodbc
WhereConn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=PRASAD;"
                      "Database=SQL Tutorial;"
                      "Trusted_Connection=yes;")

WhereCursor = WhereConn.cursor()
WhereCursor.execute('SELECT * FROM CustomerSale WHERE YearlyIncome >= 60000')

for row in WhereCursor:
    print('row = %r' % (row,))

OUTPUT

ANALYSIS

Below program select all the records from the Customer Sales table whose Yearly Income is greater than or equal to 60000.

OrderCursor.execute('SELECT * FROM CustomerSale ORDER BY YearlyIncome')

Next, we used the For loop to iterate each and every row present in the Where Cursor. Within the For Loop, we used the print statement to print records.

for row in WhereCursor:    
    print('row = %r' % (row,))

Python SQL Where Example 2

In this example we are using Wildcards to filter the data. Below program returns all the records from a table whose Occupation ends with l. 

# Python SQL Where Example
import pyodbc
WhereConn = pyodbc.connect("Driver={SQL Server Native Client 11.0};"
                      "Server=PRASAD;"
                      "Database=SQL Tutorial;"
                      "Trusted_Connection=yes;")

WhereCursor = WhereConn.cursor()
WhereCursor.execute("SELECT * FROM CustomerSale WHERE Occupation LIKE N'%l' ")

for row in WhereCursor:
    print('row = %r' % (row,))

OUTPUT