hello guys, I am trying to write this query and it seems doesnt' work.

I have a Customer table. In this table, I have two customers name: Curie Pierre, and Curie Marie.

I wrote the query below to find the customers name with 'Curie' but it didnt' work. Please advise what I need to do. Thanks a lot guys.

SELECT CUSTOMER_NAME, CUSTOMER_ID
FROM CUSTOMER
WHERE CUSTOMER_NAME = 'CURIE';

Using the = operator will find exact matches of strings you are searching for. You need to use the LIKE operator within the WHERE clause...



You might want to pick up a SQL book, like SQL for Dummies, that I have used in the past, and it is helpful.
========================================
Buh Bye!

Cheers,
Me

thanks for replying. I tried that and it says "no rows selected".

This should work:

Thanks, it works great.