How to SQL

How to convert the UUID to bin

Sometimes the UUIDs are in human unreadable format(Bin) and you want to find the string version of it. This is the query to do so:

select uuid_to_bin("ec52b511-d139-4b2a-a5d1-f903598055a7");  \\ 0xE552B5AAD1394B8AA4D1F903598033A3

then you can search the table using the result:

select XXX where uuid = 0xE552B5AAD1394B8AA4D1F903598033A3

Leave a Reply

Your email address will not be published. Required fields are marked *