What does like'%aa%' do in sql?

Question

What does LIKE'%aa%' exactly do? Is it case-sensitive?

I assume you've already consulted the documentation. What aspect(s) are unclear to you? — Damien_The_Unbeliever, May 31 '17 at 10:49
it looks for a string that has two consecutive "aa" in it and returns the string — divine, May 31 '17 at 10:49
`col like '%aa%'` finds any string that has "aa" anywhere inside it. — Gordon Linoff, May 31 '17 at 10:49
you have to check the collation. https://stackoverflow.com/questions/14962419/is-the-like-operator-case-sensitive-with-ms-sql-server. Other wise you have convert on both sides — Nayas Subramanian, May 31 '17 at 10:59
@UpasanaRoy it is case in-sensitive . ignore the negative votes. it is a good question :) . From next time frame the question properly. — divine, May 31 '17 at 11:07

score 2 · Answer 1 · answered May 31 '17 at 10:55

2

The LIKE operator is used in a WHERE clause to search for a specified pattern in a column.

e.g. WHERE CustomerName LIKE '%aa%'

Finds any values that have "aa" in any position

answered May 31 '17 at 10:55

score 1 · Answer 2 · answered May 31 '17 at 10:50

1

It retrieves all the strings having the VALUE = "aa" from DataBase.

answered May 31 '17 at 10:50

Gurdyal

score 1 · Answer 3 · answered May 31 '17 at 10:51

1

in a where clause it looks for anything which would contain 'aa'.

% acts a wildcard so anything can be before it or after it

answered May 31 '17 at 10:51

dbajtr

score 1 · Accepted Answer · edited May 31 '17 at 12:13

1

It search for a record in which the field in the condition contains the literal, in this case 'aa'.

For instance:

Select * from Employee
where Name like '%aa%'

It retrieves all employees where the names contains the literal 'aa'..

Regards!!!

edited May 31 '17 at 12:13

Dadep

answered May 31 '17 at 10:52

Pablo Aguilar

4 Answers4