SQL Statement

I have a current hard code php sql statement:

WHERE Residential_RESI.sSubdivision='Somersetie'

How do I alter this to search for a second subdivision called Palm Radish as well as Somersetie?
pda4meAsked:
Who is Participating?
 
reb73Connect With a Mentor Commented:
Missed the leading comma in my previous post -

WHERE Residential_RESI.sSubdivision IN ('Somersetie', 'Palm Radish')
0
 
reb73Commented:
WHERE Residential_RESI.sSubdivision IN (Somersetie', 'Palm Radish')
0
 
BrandonGalderisiCommented:
Leading quote, not comma ;)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.