mysql - How to run a explain query when a binary field is in the where clause

Question

I need to check the query plan for the following query on MySQL using EXPLAIN.

But the problem is the column in the where clause is binary(16). Its a guid.

explain select `title`,`ttext` 
FROM ptip inner join user on user.id = ptip.userId
where ptip.titlehash = <whatever value>

Here the titlehash is binary(16) and the query gives the following error:

'Impossible WHERE noticed after reading const tables'

I tried using; where ptip.titlehash = BINARY('24dwdfsdf') but still the same;

How do you run the above query ?

Answer 1

Ok here's how I finally solved it;

SET @hs = (SELECT titlehash FROM ptip WHERE id = 5673);
EXPLAIN SELECT `title`,`ttext` 
FROM ptip INNER JOIN USER ON user.id = ptip.userId
WHERE ptip.titlehash  = @hs

I put the value in the @hs variable and then use for explain. Fortunately the explain command explains the select only. It doesn't care about the SET operation and treat the @hs variable as just a value