Question 238339 in Mysql Question posted in
The official MySQL documentation can be found here.

Mysql – extracting emails by removing md5 hashes from text

recovered a client sql , current situation is we need to mail the users from sql .

the data format atm is : (sample) :

[email protected]
vyourclientd8572fee33aec16b3a22cc04629e1b33you3elient@yopmail.comy
fascwail.com3153741243f27e84f73a9f018f239725allg00ds@fastmail.coma
[email protected]
pwdflamingo900197393e11808e7f27ebf4331f0860c9cscrfdsold120@gmail.com
hrdpfreakdc30025992230a7e564581bf7360fe36newnewuserfir22e@gmail.com

so it user|md5|email|erors

the hard part to delete the md5 before email

5k record not worth doing it manually guessing each user mail .

Note : data cant be recovered in any other way .

thought am able to clean the last part by note++

extract mail service was able to get mail only it will get back with md5…

Tags:

2

Answers


  1. 0

    Since the data is not consistent, you can’t extract MD5.

    MD5 is a 16 byte hash or 32 bytes represented in hexadecimal.

    Record fascwail.com3153741243f27e84f73a9f018f239725allg00ds@fastmail.com includes a 33 byte hex representation 3153741243f27e84f73a9f018f239725a.
    Impossible to determine if the first or last byte is not part of the MD5 hash.

    Record [email protected] includes a hex representation a25176e5b31015a331220a35d302c5a which is 31 bytes long and can’t be a MD5 hash.

    Login or Signup to reply.
  2. 0

    you can check this:

    it search a banary string with a length of 32 chars and remove them.

    SELECT REGEXP_REPLACE('vyourclientd8572fee33aec16b3a22cc04629e1b33you3elient@yopmail.comy','[0-9,a-f]{32}','');

    sample

    mysql> SELECT REGEXP_REPLACE('vyourclientd8572fee33aec16b3a22cc04629e1b33you3elient@yopmail.comy','[0-9,a-f]{32}','');
+---------------------------------------------------------------------------------------------------------+
| REGEXP_REPLACE('vyourclientd8572fee33aec16b3a22cc04629e1b33you3elient@yopmail.comy','[0-9,a-f]{32}','') |
+---------------------------------------------------------------------------------------------------------+
| [email protected]                                                                      |
+---------------------------------------------------------------------------------------------------------+
1 row in set (0.01 sec)

mysql>
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search