Like Operator | SoloLearn: Learn to code for FREE!

-2

Like Operator

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

sql

8/2/2020 3:21:13 PM

Shaimaa Mohamed

11 Answers

New Answer

+2

Select name from world Where name like '____' ; That's 4 underscores('_') there👆

+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

+1

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

+1

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

+1

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

+1

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

+1

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

0

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?

0

Agustin Melo he/she is asking for SQL query.

0

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

0

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