SQL Statement

Posted on 2009-02-09
Last Modified: 2013-12-12
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?
Question by:pda4me
    LVL 25

    Expert Comment

    WHERE Residential_RESI.sSubdivision IN (Somersetie', 'Palm Radish')
    LVL 25

    Accepted Solution

    Missed the leading comma in my previous post -

    WHERE Residential_RESI.sSubdivision IN ('Somersetie', 'Palm Radish')
    LVL 39

    Expert Comment

    Leading quote, not comma ;)

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    If you find yourself in this situation “I have used SELECT DISTINCT but I’m getting duplicates” then I'm sorry to say you are using the wrong SQL technique as it only does one thing which is: produces whole rows that are unique. If the results you a…
    Confronted with some SQL you don't know can be a daunting task. It can be even more daunting if that SQL carries some of the old secret codes used in the Ye Olde query syntax, such as: (+)     as used in Oracle;     *=     =*    as used in Sybase …
    The viewer will learn how to dynamically set the form action using jQuery.
    The viewer will learn how to create a basic form using some HTML5 and PHP for later processing. Set up your basic HTML file. Open your form tag and set the method and action attributes.: (CODE) Set up your first few inputs one for the name and …

    794 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now