Decrypt log in mysql query

OpenEMR Development
#1

the table logs in encrypted for field comments

i want to make a query to search for a specific value in the phpmyadmin database

how i can make it?

SELECT * FROM log WHERE comments like ‘%select%’ limit 0,1

notice that field comments in encrypted and i dont want to search from the system direct in admin-> system → logs

because i need something specific from the database that can not be extracted from tihs section

#2

The comments aren’t encrypted they are encoded.

Take the comments field and use php’s base64_decode() to turn it into regular text.