# \--p-where doesn't work

**URL:** https://forum.qiime2.org/t/p-where-doesnt-work/3237
**Category:** User Support
**Tags:** sql, filtering, metadata, feature-table
**Created:** [February 28, 2018, 10:34am UTC](https://forum.qiime2.org/t/p-where-doesnt-work/3237 "2018-02-28T10:34:16Z")
**Posts on this page:** 1
**Showing post:** 4

<div class="post-metadata">

### Author: ![thermokarst](https://forum.qiime2.org/letter_avatar_proxy/v4/letter/t/8e7dd6/32.png) [@thermokarst](https://forum.qiime2.org/u/thermokarst)
#### Post date: [March 1, 2018, 10:23pm UTC](https://forum.qiime2.org/t/p-where-doesnt-work/3237/4 "2018-03-01T22:23:04Z")

</div>

> [@jjmmii](#):
>
> qiime feature-table filter-samples --i-table table\_stool-only-noNC\_freqFilt100\_minFreq100.qza --m-metadata-file metadata.tsv --o-filtered-table test --p-where "'Beating-time-min'='10'"

Thanks for sending your data in a DM. A few comments:

1. Quoting is hard, and we would like to make this easier in the future, but for now, we are stuck reading the [sqlite.org](http://sqlite.org) docs to understand what to do. If you use double quotes around your column, this works as expected:

```bash
qiime feature-table filter-samples \
  --i-table table_stool-only-noNC_freqFilt100_minFreq100.qza \
  --m-metadata-file metadata.tsv \
  --o-filtered-table test \
  --p-where "\"Beating-time-min\"='10'" 

```

1. Your table you provided is already filtered to only have a subset of the `Beating-time-min=10` samples, interrogating your provenance it looks like this is a side-effect of all the frequency filtering you applied (looks like you did that 4 times, two `filter-samples` and two `filter-features`). Anyway, the table you sent has 88 samples, and all of them are `Beating-time-min=10`. I mention this so that when you run the command and the table appears to be unchanged, this is why. After filtering, I see 88 samples and 131 features.

---

_[View the full topic](https://forum.qiime2.org/t/p-where-doesnt-work/3237)._