# Help with a MySQL search query

**URL:** <https://forum.kirupa.com/t/help-with-a-mysql-search-query/256933>\
**Category:** Uncategorized\
**Created:** [April 8, 2008, 11:19pm UTC](https://forum.kirupa.com/t/help-with-a-mysql-search-query/256933 "2008-04-08T23:19:07Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![gokujou](https://avatars.discourse-cdn.com/v4/letter/g/85e7bf/32.png) [@gokujou](https://forum.kirupa.com/u/gokujou)\
**Post date:** [April 8, 2008, 11:19pm UTC](https://forum.kirupa.com/t/help-with-a-mysql-search-query/256933/1 "2008-04-08T23:19:07Z")

</div>

Hello,  
I am trying to make a search that will look into multiple fields in my mysql table but all I have got to work so far is this that one searches one field.

```php

$query = "SELECT * FROM ln_establishments WHERE est_name LIKE '%".$_POST['search_term']."%' ";

```

I have also tried doing a “WHERE est\_name, est\_desc” but no luck there so it must not be correct syntax. Any help or pointers would be awesome. Thank you!