<div>
Sneaky Bastard doesn't throw and error. Sometimes the query runs and does not return results. It doesn't look to be the query its a glitch in how I'm triggering a search.
</div>


Sneaky Bastard doesn't throw and error. Sometimes the query runs and does not return results. It doesn't look to be the query its a glitch in how I'm triggering a search.

<div>
Dammit i figured it out, bringing in the wrong number for the search
</div>


Dammit i figured it out, bringing in the wrong number for the search

<div>
That confirms that the syntax is correct. &nbsp;Maybe start with one clause first (the LIKE) and see if there are results. &nbsp;Then add the latitude filter and see what's left, then add the last filter.
</div>


That confirms that the syntax is correct.  Maybe start with one clause first (the LIKE) and see if there are results.  Then add the latitude filter and see what's left, then add the last filter.

<div>
<div class="content wysiwyg-content">
I know the syntax is not correct. How would I go about using multiple and statements?<br />
<br />

<pre><code id="code-10-27731757-1">SELECT * FROM `search` WHERE company_name LIKE '%pizza%' 
and 
latitude BETWEEN 38.69852058020537 AND 41.224260426268195 
AND 
longitude BETWEEN -75.97329101562502 AND -75.97329101562502 
LIMIT 0, 25</code></pre>
</div>
</div>


I know the syntax is not correct. How would I go about using multiple and statements?

(CODE)

Multiple MySql AND Statements

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.