how to write SQL - WHERE column LIKE 'something%' in python?

Question

I'm searching an SQL table for customers who's name starts with my input and i have problem writing the "Starting With" logic, it works fine when its WHERE ? =. i'm using pyodbc and using driver ODBC Driver 17 for SQL Server

i've seen alot of answers on similar problems but they always refer to using the code %s, and that does not work when i try it

I've tried many different ways of writing LIKE '%' but i cannot find any examples of this

my current code is:

  cursor.execute("select CustomerName, CustomerNum From customer WHERE Company = ? AND CustomerName = ?", Company, CustomerName)
    result = cursor.fetchall()
    for row in result:
      print (row)

CustomerName var set to "Mic" and the the result should be:

Microsoft

Micro systems

etc..

Thanks you

which database are you pulling data from? CONCAT might not be available, you might have to do a '%'+searchstring+%' — MEdwin
– MEdwin, Commented Feb 6, 2019 at 10:11

Barmar · Accepted Answer · 2019-02-07 02:12:39Z

3

You need to concatenate the parameter with the % wildcard. In MySQL you use the CONCAT() function, in SQL-Server you use the + operator.

Also, the parameters that fill in the placeholders should be in a tuple, not separate arguments to cursor.execute().

MySQL:

  cursor.execute("select CustomerName, CustomerNum From customer WHERE Company = ? AND CustomerName LIKE CONCAT(?, '%')", (Company, CustomerName))

SQL-Server:

  cursor.execute("select CustomerName, CustomerNum From customer WHERE Company = ? AND CustomerName ? + '%'", (Company, CustomerName))

edited Feb 7, 2019 at 2:12

answered Feb 6, 2019 at 10:00

Barmar

789k57 gold badges554 silver badges669 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

how to write SQL - WHERE column LIKE 'something%' in python?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related