How to get a conversion row from idvisitor

Support & Bugs
1

idvisitor in table prefix_log_conversion is saved as binary. Checking the Piwik PHP code, it seems like the function bin2hex is used to convert the id to the correct database format. Is there any way to do this in SQL? Something like

SELECT * FROM prefix_log_conversion WHERE idvisitor = SOME_FUNCTION('1e679b5b8f2');
2

Hi, this is no answer, but someone else had the same question here:

3

I use

SELECT hex(idvisitor) FROM piwik.piwik_log_conversion where hex(idvisitor) = 'cab238d0fefc3424'

4

Nice one, thank you!