• We value your experience with Plesk during 2025
    Plesk strives to perform even better in 2026. To help us improve further, please answer a few questions about your experience with Plesk Obsidian 2025.
    Please take this short survey:

    https://survey.webpros.com/

Editing User/Password Lookup

KrazyBob

Regular Pleskian
I'm in a jam.

How can I append to this mysql code so that it takes its password - if plain text - and writes it back over itself. But leaves it alone if it encrypted?

Your help is appreciated.

Code:
select CONCAT(mail_name,"@",name) as email_address,accounts.password from mail left join domains on domains.id=mail.dom_id left join accounts on accounts.id=mail.account_id;
 
Back
Top