• Inviting everyone who uses WordPress management tools in Plesk
    The Plesk team is conducting a 60-minute research session that includes an interview and a moderated usability test.
    To participate, please use this link .
    Your experience will help shape product decisions and ensure the tools better support real-world use cases.

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