mysqli_query SELECT LIKE function not working
<p>Im getting query error, im using the like LIKE sql function to search for the name submitted by the user.</p>

<p>But msqli_query is giving an error if i remove the LIKE function it works but doesn't works with the LIKE function</p>

<pre><code>&lt;!DOCTYPE html&gt;
&lt;html&gt;
&lt;head&gt;
&lt;title&gt;Search Users&lt;/title&gt;
&lt;/head&gt;
&lt;body&gt;
&lt;form action="&lt;?php echo htmlspecialchars($_SERVER["PHP_SELF"]);?&gt;"method="GET"&gt;

Name: &lt;input type="text" name="name"&gt;&lt;/input&gt; 

&lt;input type="submit" name="searchusers" value="Submit"&gt;&lt;/input&gt; &lt;/br&gt;

&lt;/body&gt;
&lt;/html&gt;

&lt;?php require('connect.php');

$name = @$_GET['name'];


if ($_SERVER["REQUEST_METHOD"] == "GET")
{   
$select123 ="SELECT username FROM users WHERE username LIKE ='%".$name."%'"; 
$check = mysqli_query($conn, $select123) or die("query error");
mysqli_num_rows($check) or die("Couldnt not find the Specified username");

}
?&gt;
</code></pre>

<p>Please help</p>