How to do SELECT * FROM table WHERE anycolumn LIKE '℅something℅' in SQL

Answer 1

For eg- there is an Employee table.

SELECT * FROM Employee
WHERE name LIKE "%a%";

This will fetch all details of the employees whose name contains the letter "a".

Answer 2

If i don't want to specify witch column?

Answer 3

Then there is no point of using LIKE because it is usually used with the WHERE clause and it means you have to specify a condition.

Answer 4

I want select all rows from anycolumn that containt '℅some%'

Answer 5

I want to filter any columns

Answer 6

Kensy Master Will that is not possible the way you want it.

You must apply LIKE to all columns, each separated by a OR condition.

Answer 7

If i have 100 columns

Answer 8

Yea I can see where you are heading with that but unfortunately I don't think you can do that.

Still let us wait for more responses.