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.
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;