How to select with a binary field ? (php,mysql)

Question

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;

Return 0 row.

Does anyone know why?

Why makes you say "not working"? Do you get an error? Does it not produce the results you expect? Does it produce no results? — wallyk
– wallyk, Commented Mar 21, 2012 at 6:59

jebberwocky · Accepted Answer · 2012-03-21 07:00:19Z

4

Answering my own question.

Just figured out:

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

Does anyone know better solution?

answered Mar 21, 2012 at 7:00

jebberwocky

1,0873 gold badges11 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

score 1 · Accepted Answer · 2012-03-21 06:56:25Z

1

Try below :

add BINARY in where clause.

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

answered Mar 21, 2012 at 6:50

user319198