Skip to content

Instantly share code, notes, and snippets.

@andikasputra

andikasputra/preferences.sql

Last active November 25, 2018 03:32
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andikasputra/3d8e26fa9c5fc8abc4694fa0c8340744 to your computer and use it in GitHub Desktop.
Save andikasputra/3d8e26fa9c5fc8abc4694fa0c8340744 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
preferences.sql
SELECT
MAX(CASE WHEN (pref_name = 'smtp_host') THEN pref_value ELSE NULL END) AS smtp_host,
MAX(CASE WHEN (pref_name = 'smtp_port') THEN pref_value ELSE NULL END) AS smtp_port,
MAX(CASE WHEN (pref_name = 'smtp_user') THEN pref_value ELSE NULL END) AS smtp_user,
MAX(CASE WHEN (pref_name = 'smtp_pass') THEN pref_value ELSE NULL END) AS smtp_pass
FROM preferences
WHERE pref_group = 'email';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment