'How to search JSON array in MySQL using sqlalchemy?

I have one JSON column in my table. I want to filter by this column using sqlalchemy with Python and MySQL. I've tried in this way, but unsuccessfully.

My column: ["1", "2", "3", "4", "5"]

myTable.select().where(func.json_contains(f'"{mycolumn}"', f'"{myArray}"'))
pythonmysqlsqlsqlalchemy


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions