opposite of LIKE "%foo%"

[godisatheist]

Hi,

SELECT * FROM table WHERE foo LIKE "%barbarbar%"
will contain rows where foo contains "barbarbar"
=> for example where foo is "barbarbarbarbar"

What I want, are the rows where "barbarbar" contains foo
=> for example where foo is "barbar"

how to do it?

Greetings, Andreas

[r937]

What I want, are the rows where "barbarbar" contains foo
=> for example where foo is "barbar"

would you please rephrase the question?

which of those is the column? and which is the constant?

[godisatheist]

Hi,

foo is always the coloumn in this example.

I think I found an possible solution:

SELECT * FROM table WHERE "barbarbar" LIKE CONCAT('%' , foo , '%')

Greetings, Andreas