MySQL fuzzy query to remove whitespace related issues?

MySQL fuzzy query to remove the space problem??
$sql = "Select MINGC from info WHERE 1=1";

Fuzzy judgment
if ($MINGC! = "") {
$sql. = "and MINGC like '% $MINGC% '";
}

How to remove a space when the name text box blurs a query "trim ($MINGC) can be used

But the problem is = = "First hit a space in the input fuzzy condition/or vice versa

"Remove left and right spaces at the same time, and can make fuzzy queries"

Wait.......

------Solution--------------------
Trim () is to remove the left and right space ah, ... What's going on today?
------Solution--------------------
if (!empty ($MINGC)) {
$sql. = "and MINGC like '%trim ($MINGC)% '";
}

