如何选择一个二进制字段? (php，mysql) [英] How to select with a binary field ? (php,mysql)

问题描述

尝试在mysql语句中选择使用"where"子句: 例如 表:带有ID列的X，该列是BINARY数据类型.然后保存在php中的变量中

Try to select use "where" clause in a mysql statement: e.g. Table: X with a ID column which is BINARY data type. Then save in a variable in php

$aid = $row["id"];

稍后尝试从表中选择时如何使用此变量

How do i use this variable later when I try to select from table

$where = "where `ID` = '$aid'";
$query = "SELECT * FROM X ".$where;

返回0行.

有人知道为什么吗?

推荐答案

回答我自己的问题.

只要弄清楚:

$where = "where HEX(ID) = 'bin2hex($aid)'";
$query = "SELECT * FROM X ".$where;

有人知道更好的解决方案吗?

Does anyone know better solution?

这篇关于如何选择一个二进制字段? (php，mysql)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！