How to check if a string contains any string of a column in MySQL and vice versa?

Question

By vice versa, I mean, check if any of the strings in a column contains the string.

Example:

String a = "Peperoni"

MySQL column:

{
    "PPeperoni_123",
    "roni",
    "hello world"
}

It should return the first 2 rows.

(Note: im looking for the query string for this)

Solution

Not sure if I understand you correctly, but are you maybe looking for this:

SELECT ... WHERE column LIKE "%string%" OR string LIKE CONCAT("%", column, "%")

Comments

[Zananok]

Thank you, that is exactly what I am looking for.

[Zananok]

Thank you, that also helps me on a similar issue.

[aidonsnous]

LIKE CONCAT("%", column, "%") is not secure if the value of the column contains %

[aidonsnous]

Sounds like can not return that result it compares string phonetically