• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

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?
0
pda4me
Asked:
pda4me
  • 2
1 Solution
 
reb73Commented:
WHERE Residential_RESI.sSubdivision IN (Somersetie', 'Palm Radish')
0
 
reb73Commented:
Missed the leading comma in my previous post -

WHERE Residential_RESI.sSubdivision IN ('Somersetie', 'Palm Radish')
0
 
BrandonGalderisiCommented:
Leading quote, not comma ;)
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now