ogc:PropertyIsEqualTo

?SERVICE=WFS&VERSION=1.0.0&REQUEST=GetFeature&TYPENAME=p5_default_db:TEST_PERMS&SRSNAME=EPSG:3003&Filter=<ogc:Filter>...

Sql like filter:

 `A_STATUS` in('NORMAL','WAITING')

<ogc:Filter>
        <ogc:Or>
            <ogc:PropertyIsEqualTo>
                <ogc:PropertyName>A_STATUS</ogc:PropertyName>
                <ogc:Literal>NORMAL</ogc:Literal>
            </ogc:PropertyIsEqualTo>
            <ogc:PropertyIsEqualTo>
                <ogc:PropertyName>A_STATUS</ogc:PropertyName>
                <ogc:Literal>WAITING</ogc:Literal>
            </ogc:PropertyIsEqualTo>
        </ogc:Or>
    </ogc:Filter>

Note: Dont forget to escape XML strings in sending this filter to use in scripting with curl or wget. This example in sting in htpp request should look like that:

&lt;ogc:Filter&gt;
    &lt;ogc:Or&gt;
        &lt;ogc:PropertyIsEqualTo&gt;
            &lt;ogc:PropertyName&gt;A_STATUS&lt;/ogc:PropertyName&gt;
            &lt;ogc:Literal&gt;NORMAL&lt;/ogc:Literal&gt;
        &lt;/ogc:PropertyIsEqualTo&gt;
        &lt;ogc:PropertyIsEqualTo&gt;
            &lt;ogc:PropertyName&gt;A_STATUS&lt;/ogc:PropertyName&gt;
            &lt;ogc:Literal&gt;WAITING&lt;/ogc:Literal&gt;
        &lt;/ogc:PropertyIsEqualTo&gt;
    &lt;/ogc:Or&gt;
&lt;/ogc:Filter&gt;

Note: Dont use enter and spaces!

&lt;ogc:Filter&gt;&lt;ogc:Or&gt;&lt;ogc:PropertyIsEqualTo&gt;&lt;ogc:PropertyName&gt;A_STATUS&lt;/ogc:PropertyName&gt; (…)