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