Update a filter in a SQL select code : <p>I want to update the a filter in the following code I wrote. I am confused how to put.</p>

<p>Code is:</p>

<pre><code>$query = "SELECT  P.`Building_info` as `name`,P.`Area` as `area`,
            avg(
                CASE 
                    WHEN P.`Bedroom`='4' 
                    THEN P.`$price`
                    ELSE NULL 
                END
            ) AS 'Beds_4',
            avg(
                CASE 
                    WHEN P.`Bedroom`='5' 
                    THEN P.`$price`
                    ELSE NULL 
                END
            ) AS 'Beds_5'
        FROM    All_Rent P
        WHERE P.Building_info&lt;&gt;''
        AND Sale_Rent='$accom'
        AND converted_date &gt; '$min_date'
        GROUP BY P.`Building_info`";
</code></pre>

<p>I want to add a filter where <code>Area = "Euston Road"</code> i.e. select only the areas with the name "Euston Road"</p>

<p>Can anyone help? </p>
