CODEWITHSUNDEEP
sqloracle-database
Eoin2211
Eoin2211

Reputation: 911

Displaying records that contain a certain letter in SQL

I have a SQL table called Customer containing a column called customer_country. I would like to display all the countries that contain the letter u.

How would I do this? Im guessing its along the lines of 

  select customer_country
  from Customer;

and using a like statement perhaps? Regards

Upvotes: 0

Views: 1227

Answers (1)

Avdhey
Avdhey

Reputation: 79

select customer_country 
from Customer 
where customer_country like '%u%'

Upvotes: 2

Related Questions