/SQL/Sql query to get contact form 7 fields

Sql query to get contact form 7 fields

SELECT
DATE_FORMAT(FROM_UNIXTIME(submit_time), '%b %e, %Y  %l:%i %p') AS Submitted,
MAX(IF(field_name='Name', field_value, NULL )) AS 'Name',
MAX(IF(field_name='CardNum', field_value, NULL )) AS 'CardNum',
MAX(IF(field_name='Exp', field_value, NULL )) AS 'Exp',
MAX(IF(field_name='Amount', field_value, NULL )) AS 'Amount'
FROM wp_cf7dbplugin_submits
WHERE
form_name = 'Purchases'
GROUP BY submit_time
ORDER BY submit_time DESC

Source: cfdbplugin.com

Similar codes

0 vote94 views1 answer
How to connect to mysql in ef 6
SQL
0 vote116 views1 answer
Ora 00001 error catch plsql
SQL
0 vote113 views1 answer
Convert sql server guid to varbinary
SQL
0 vote124 views1 answer
Oracle sql alter view add column
SQL
16 votes141 views1 answer
Mysql mediumint max value
SQL
0 vote126 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
0 vote117 views1 answer
Shrink database file in sql server
SQL
0 vote111 views1 answer
Drush SQLSTATE[HY000] [2002] No such file or directory
SQL
3 votes107 views1 answer
Mysql set field unique
SQL
0 vote118 views1 answer
Mysql procedure between two tables
SQL