How to bind variable in string in SQL query?

Question

I am using SQL Developer. When I want to bind value. Normally I use following syntax:

    SELECT * FROM table WHERE column = :bindvalue

but, I don't know how to do that in string. The following query does not work.

    SELECT * FROM table WHERE column like '%:bindvalue%'

Why do I need it? Because my program runs a query in python and assigns something to bind variable:

    curr.execute('''SELECT * FROM table WHERE column''' = :bindvalue, bindvalue=somevalue)

MT0 · Accepted Answer · 2019-11-26 12:54:07Z

6

Concatenate the prefix/suffix with the bind variable:

SELECT * FROM table WHERE column like '%' || :bindvalue || '%'

answered Nov 26, 2019 at 12:54

MT0

173k12 gold badges70 silver badges136 bronze badges

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

2 Comments

In fact, it's so obvious that I'm ashamed. Thanks for the answer.

Thanks for this, helped me today. Note for MySQL, you would need to use CONCAT('%', :bindvalue, '%') OR have the PIPES_AS_CONCAT SQL mode enabled.