Re: write trim into INSERT and SELECT Queries

[Rick James]

I usually approach it this way (when using PHP):

$wheres = array();
if (...)   // if need to check the company name
{
    $x = mysql_real_escape_string($company);
    $wheres[] = "company = '$x';
}
if (...)   // if need to check foo
{
    $x = mysql_real_escape_string($foo);
    $wheres[] = "foo= '$x';
}
...
$where_str = implode(' AND ', $wheres);
$sql = "SELECT ... FROM tbl
         WHERE  $where_str
         ORDER BY ...";