Variable in string containing SQL query - Python

Question

I have a string set up the following way:

sql_string = ( """ select * from schema.table where column1 like '%object%' and column2 = '%s' """)%(x)

Unfortunately when I run my script, I get the following error:

TypeError: not enough arguments for format string

Is there any way for me to have a variable in my query string? I suspect that the percent signs in the column1 section of the query are what is causing issues.

Thanks!

Yassine Faris · Accepted Answer · 2018-04-27 12:03:07Z

2

You can escape the % using an other %:

sql_string = ( """ select * from schema.table where column1 like '%%object%%' and column2 = '%s' """)%(x)

edited Apr 27, 2018 at 12:03

answered Apr 25, 2018 at 12:54

Yassine Faris

1,0118 silver badges28 bronze badges

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

Comments

akshat · Accepted Answer · 2018-04-25 12:40:53Z

1

Use format function:

sql_string = ( """ select * from schema.table where column1 like '%object%' and column2 = '{}' """).format(x)

answered Apr 25, 2018 at 12:40

akshat

1,2151 gold badge8 silver badges24 bronze badges

Collectives™ on Stack Overflow

Variable in string containing SQL query - Python

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related