Hi, MySQL (version 5.1.45 , windows based) AES_DECRYPT () function is not working properly,
If I removed Order by clause from the following query it works Fine. If I add order by it resulting blob[empty] value. >> select S.semyear as semester, S.part as part, S.code as code, S.subject as Title, AES_DECRYPT(R.cia, 'TEMPSTR') as cia, AES_DECRYPT(R.sem, 'TEMPSTR') as sem, AES_DECRYPT(R.result, 'TEMPSTR') as result, R.exam, R.regarr from examresults as R, g_subject as S where S.code = R.code and R.regno = 'A08BBD03' Order By S.semyear, R.rank, S.code, R.regarr , R.exam Can i have advise Please? Thank you. Vikram