MySQL Fuzzy query

MySQL Fuzzy query

The variables that appear in double quotes are automatically parsed.
$sql = "SELECT * from oneself WHERE name like '%{$colname _recordset1} ' LIMIT {$startRow _recordset1}, {$maxRows _recordset1} ";
$Recordset 1 = mysql_qu

The variables that appear in double quotes are automatically parsed.
$sql = "SELECT * from oneself WHERE name like '%{$colname _recordset1} ' LIMIT {$startRow _recordset1}, {$maxRows _recordset1} ";
$Recordset 1 = mysql_query ($sql) or Die (Mysql_error ());

{} on either side of the variable directly indicates that it is a variable and the name of the variable,

Query Chinese characters,
SELECT * FROM mytable where mysqlname like "%%"

If the size Word distinguishes query English characters,
SELECT * FROM MyTable where mysqlname like Binary ("%a%")

If all the above conditions are to be
SELECT * FROM mytable where mysqlname like "% not%" and mysqlname like Binary ("%a%")

Select Id,name from depart where name like%?% This is just a fuzzy query for name

I want to make a fuzzy query on the ID, what should I do?

Select Id,name from depart where id like '%123% '