Where Clause Project

I was prompted to perform a where clause and when checking my answer the box said " Take a look at the table schema. Notice that the birthday column is actually a TEXT column. No sweat, there are still ways to find users who are born in the 80’s!"

Is there a rule about which operator to use with the Where clause (i.e. Like is used with Text, = is used with Integers, etc.)?

Hello @raqueldevore, you can use the = operator with text:

SELECT *
FROM table1
WHERE COLUMN1 = "data1";

You can also use the LEN() function to find the length of the string, so you could do:

SELECT *
FROM table1
WHERE LEN(COLUMN1) = 5;

I hope this help!
P.S. I moved this thread into the SQL Get Help category.

ah, okay, thank you!

1 Like

This topic was automatically closed 41 days after the last reply. New replies are no longer allowed.