<div>
Since you are already using double quotes, you can leave $poID in the string and let php variable substitution take place.<br />
<br />
$q=&quot;SELECT poID FROM<br />
in_transit_summary WHERE poID<br />
LIKE '$poID%' group by poID&quot;;<br />
<br />
To be clear, if poID is a string (varchar), then you need single quotes around it when searching. &nbsp;If it is a number, it will need to be cast to a varchar first, and the same LIKE expression.
</div>


Since you are already using double quotes, you can leave $poID in the string and let php variable substitution take place.

$q="SELECT poID FROM
in_transit_summary WHERE poID
LIKE '$poID%' group by poID";

To be clear, if poID is a string (varchar), then you need single quotes around it when searching.  If it is a number, it will need to be cast to a varchar first, and the same LIKE expression.

<div>
Thanks. &nbsp;Had my single quote in wrong places...
</div>


Thanks.  Had my single quote in wrong places...

<div>
<div class="content wysiwyg-content">
I am having problem with syntax for a query that grabs a variable value and then a wildcard<br />
<br />
$q=&quot;SELECT poID FROM in_transit_summary WHERE poID LIKE &quot;.$poID.&quot;% group by poID&quot;;<br />
<br />
I keep getting &nbsp;invalid qry error
</div>
</div>


I am having problem with syntax for a query that grabs a variable value and then a wildcard

$q="SELECT poID FROM in_transit_summary WHERE poID LIKE ".$poID."% group by poID";

I keep getting  invalid qry error

MYSQL - LIKE with variable and wildcard - Syntax help

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.