Can I use logic operators in a LIKE pattern?

Exemple:

```
SELECT * FROM foo WHERE bar LIKE '%something || somethingelse%';

```

**Note 1 :** My question is for mySQL, but an overview of how other implementations of SQL treat such queries will be helpful.

**Note 2 :** If this is not possible, is there any alternatives besides using

```
WHERE bar LIKE '%something' OR bar LIKE 'somethingelse%'

```

What I want to accomlish is to be able to inject some string into the LIKE pattern and be able to return results from the database that meet that pattern.