mysql在做jdbc時like binary該怎麽寫

//$str="abc";

$str="張";

// preg_match("/[\x80-\xff]/", $path)判斷中文,binary不支持中文的使用

if(preg_match("/[\x80-\xff]/", $path)) {

$sql = "SELECT id FROM student WHERE name like '$str"; //卻掉 binary

}else{

$sql = "SELECT id FROM student WHERE binary name like '$str'";

}