How to make a query to search for a word in a string?

Question

SQL

Tell me how to make a query in SQL to search in a string?
For example, there is a column namewith entries

FootBall Adidas 20
FootBall Nike Sm
BasketBall Adidas Red
PinkBall Adidas RT

How do I enter the word in the search adidas, get in response all the columns where the name contains the word adidasand it doesn’t matter if there are capital letters there or not.
Just driving in basketballto get the result of 2 columns.

Answer 1

SELECT LOWER(название_столбца)
FROM название_таблицы 
WHERE название_столбца
LIKE '%слово%'