# Filter: Return a row with two matching columns?

**URL:** <https://community.dreamfactory.com/t/filter-return-a-row-with-two-matching-columns/3543>\
**Category:** REST API\
**Created:** [January 1, 2017, 8:57pm UTC](https://community.dreamfactory.com/t/filter-return-a-row-with-two-matching-columns/3543 "2017-01-01T20:57:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sal](https://avatars.discourse-cdn.com/v4/letter/s/58f4c7/32.png) [@Sal](https://community.dreamfactory.com/u/Sal)\
**Post date:** [January 1, 2017, 8:57pm UTC](https://community.dreamfactory.com/t/filter-return-a-row-with-two-matching-columns/3543/1 "2017-01-01T20:57:13Z")

</div>

Is there a way to GET a record where two columns in the same row match? For example, If FIELD1 and FIELD13 both had the name Bob in the same row in a mysql database, could I return that record?

I’m trying to return all rows where FIELD1 and FIELD13 are equal to each other.

---

<div class="post-metadata">

**Author:** ![rbarriuso](https://avatars.discourse-cdn.com/v4/letter/r/e99b99/32.png) [@rbarriuso](https://community.dreamfactory.com/u/rbarriuso)\
**Post date:** [January 2, 2017, 11:33am UTC](https://community.dreamfactory.com/t/filter-return-a-row-with-two-matching-columns/3543/2 "2017-01-02T11:33:26Z")

</div>

I guess you can implement that feature using a script service which accesses the DB directly.