Like Operator

Question

What should i type to get only, the names that have 4 characters only?

Pls, complete the code

Select name from world
Where name like

Answer 1

Select name from world
Where name like '____' ;

That's 4 underscores('_') there👆

Answer 2

Shaimaa Mohamed there is no need to put parentheses, I have put it for explanation purpose only.
Every under score in LIKE represents one single character, for 4 characters you have to put 4 of them

Answer 3

Arsenic great i understand 👌
Would you help me, if i want to return the values with the same exactly name
(Ex. One called Richard Richard so i want to return both)

Select name from world
Where name like

Answer 4

Shaimaa Mohamed for that use :-
Where name = "Richard";

Answer 5

Arsenic I don't know exactly the people with the same surname and forename
And I want to return all of them, get me?😉

Answer 6

For that you must be having an surname attribute also in the table.

Answer 7

I don't get it
But i do appreciate your help 🌹

Answer 8

I want to make sure that I understood correctly, you want to select a name ( from, let's say, an array of character's names) that have only 4 letters on them?

Answer 9

Agustin Melo he/she is asking for SQL query.

Answer 10

Arsenic thanx🤗
would you explain why we put it in parenthesis?

Answer 11

Agustin Melo i want to return the names which have 4 letters only