$sql = "SELECT * FROM test_user WHERE uname = '$uname' AND upwd = '$upwd'";
上面的不区分大小写
$sql = "SELECT * FROM test_user WHERE binary uname = '$uname' AND binary upwd = '$upwd'";上面的区分大小写
本文介绍了如何使用SQL查询来区分或不区分大小写。通过两个示例,展示了当需要进行大小写敏感匹配时如何调整查询语句。
$sql = "SELECT * FROM test_user WHERE uname = '$uname' AND upwd = '$upwd'";
上面的不区分大小写
$sql = "SELECT * FROM test_user WHERE binary uname = '$uname' AND binary upwd = '$upwd'";上面的区分大小写
被折叠的 条评论
为什么被折叠?