mysql模糊查詢

mysql模糊查詢

雙引號中出現的變數將自動被解析。
$sql = "SELECT * FROM oneself WHERE name like '%{$colname_Recordset1}' LIMIT {$startRow_Recordset1}, {$maxRows_Recordset1}";
$Recordset1 = mysql_qu

雙引號中出現的變數將自動被解析。
$sql = "SELECT * FROM oneself WHERE name like '%{$colname_Recordset1}' LIMIT {$startRow_Recordset1}, {$maxRows_Recordset1}";
$Recordset1 = mysql_query($sql) or die(mysql_error());

{} 放在變數兩邊是直接指明這是個變數及該變數的名字，

查詢漢字,
select * from mytable where mysqlname like "%不%"

如果是大小字區分查詢英文字元,
select * from mytable where mysqlname like Binary("%A%")

如果上述條件均要
select * from mytable where mysqlname like "%不%" AND mysqlname like Binary("%A%")

 

select id,name from depart where name like %?%這隻是對name進行了模糊查詢

我想在對id進行模糊查詢,應該怎麼樣做?
 
 

select id,name from depart where ID like '%123%'