1
2
3

SELECT column_name(s)
FROM table_name
WHERE column_name LIKE 

Example 1

There is a table "Persons":

Now we want to select all individuals who live in the city, whose name is begins

For this we use this query:

1
2

SELECT * FROM Persons
WHERE City LIKE 's%'

"%"

Query Result:

Example 2

Now we want to select all individuals who live in the city, whose name is

For this we use this query:

1
2

SELECT * FROM Persons
WHERE City LIKE '%s'

Query Result:

Example 3

Now we want to select all individuals who live in the city, whose name is contains в себе буквы "". Не важно, в каком месте будут находиться данные символы, в начале или конце слова.

1
2

SELECT * FROM Persons
WHERE City LIKE '%%'

Query Result:

Now we want to select all individuals who live in the city, whose name is not contains в себе буквы "". Используем ключевое слово NOT.

1
2

SELECT * FROM Persons
WHERE City NOT LIKE '%%'

Query Result: