有可能从php / c文件中创建sql函数

Question

I have a table in my data base and one of the fields is encoded by a php function. now I need to make a function to decode that field in mysql side. something like this:

SELECT permissions,decodePermission(id,permissions) as decoded_permissions FROM table

I try to use CREATE TABLE in mysql but it is very weak and in sql i don't have functions like explode(), base64_decode() , md5() (that is exists in php). so now I wanna to know it is possible to make a function in mysql from a php,c or perl file? something like this: LOAD FILE 'path/to/c/file'

Answer 1

Create a function via php /c isnt possible. What kind of encoding did you use? What functions?

Anyways, there are crypto functions in Mysql. have a look here https://dev.mysql.com/doc/refman/5.5/en/encryption-functions.html

It is also not pretty secure to get the decrypted data from mysql if you are not using ssl