Im working on a search panel and I want to SELECT all the data in all columns that has this certain keyword.

usually, if you want to select something, it goes like this:

```
SELECT * FROM TableName WHERE columnName = "%as%";

```

but this only displays data that has "as" somewhere in that column I specified, I want to select all the data from all the columns that has that keyword.

here's what I want to happen:

```
SELECT * FROM TableName WHERE <any column> = "%as%";

```

please enlighten me if something like that exists. Thankyou.