Select data using VARBINARY in PHP [duplicate]

Question

I have a table called mytable that contains a row with the following data:

uid: 1 (type: int(10))

email: it is visible as 971f2d23 in phpMyAdmin (type: varbinary(16))

I want to run a SELECT query like that:

$conn->query("SELECT * FROM mytable WHERE email=971f2d23");

but this doesn't return any rows.

I also tried:

$conn->query("SELECT * FROM mytable WHERE email=0x971f2d23");

but still no rows.

Any help would be appreciated.

Thanks!

Enclose the value you are searching for with quotes as in '0x971f2d23'. — Dave
– Dave, Commented Dec 5, 2018 at 15:14
But that should still work/apply with a varbinary column no? — Dave
– Dave, Commented Dec 5, 2018 at 15:18
Thanks @tadman ... learn something new every day (which is a good thing). — Dave
– Dave, Commented Dec 5, 2018 at 16:40

tadman · Accepted Answer · 2018-12-05 16:35:02Z

1

Try this

$conn->query("SELECT * FROM mytable WHERE email='971f2d23'");

tadman

212k23 gold badges237 silver badges266 bronze badges

answered Dec 5, 2018 at 16:23

Yogesh

93 bronze badges

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

1 Answer 1