Use explode function inside SQL query

I have a database db with a column named type which is a string.

I want to do an SQL query like this one :

SELECT * FROM db WHERE explode(",", type) = 'action'

Yet it doesn't work because I can't use the explode function in an SQL query. So how can I solve this problem ?

source https://stackoverflow.com/questions/73639583/use-explode-function-inside-sql-query