SQLAlchemy pass parameters with like '%STRING%' in raw sql

Question

I have a sql:

select *
from my table
where exists (
    select
    from unnest(procedure) elem
    where elem like '%String%'
          )

It works well when directly execute in database ide.

My question is how can I set 'String' as a parameters ?

I have tried:

String = 'hello world'

my_query = '''
    select *
    from my_table
    where exists (
        select
        from unnest(procedure) elem
        where elem like '% :String %'
              )
    '''

result=connection.execute(text(my_query),String=String)

However it returns nothing,I think maybe "like %" is special ?

Any friend can help ?

John Gordon · Accepted Answer · 2023-01-27 02:46:26Z

2

I think a better solution is to put the percent signs in the variable itself, and have only :String in the query:

String = '%hello world%'
my_query = '''
    ...
    where elem like :String
'''

answered Jan 27, 2023 at 2:46

John Gordon

33.8k9 gold badges48 silver badges72 bronze badges

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

Collectives™ on Stack Overflow

SQLAlchemy pass parameters with like '%STRING%' in raw sql

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