# Is there a MYSQL search limit?

**URL:** <https://forum.kirupa.com/t/is-there-a-mysql-search-limit/246013>\
**Category:** programming\
**Created:** [December 6, 2007, 10:46am UTC](https://forum.kirupa.com/t/is-there-a-mysql-search-limit/246013 "2007-12-06T10:46:33Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![onemhunki](https://avatars.discourse-cdn.com/v4/letter/o/c57346/32.png) [@onemhunki](https://forum.kirupa.com/u/onemhunki)\
**Post date:** [December 6, 2007, 10:46am UTC](https://forum.kirupa.com/t/is-there-a-mysql-search-limit/246013/1 "2007-12-06T10:46:33Z")

</div>

Folks, I have a complicated search form that searches 15+ fields of a database table. I’ve linked all the searches with AND, eg: WHERE first\_name LIKE ‘%$search1%’ AND but when I start to use greater than \> or BETWEEN the whole thing throws out all fields. I just wondered if there was a limit to the amount of searches or I’m linking them in the wrong way?

Any advice as usual greatly appreciated.