Pick all queries equivalent to the following one:

select * from numbers where textvalue = 'one'

select * from numbers where textvalue like '%one%'

select * from numbers where textvalue like '%one'

select * from numbers where textvalue like 'one'

select * from numbers where textvalue like 'one%'

select * from numbers where textvalue like one

Explanation

% wildcard character matches zero, one or more characters in a string.

like-operator

Приєднуйся і вивчай SQL

або Дізнайся більше про Тести з SQL онлайн