/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 vote113 views1 answer
Is there a way to use read_sql_query and the query has WHERE column = Variable?
SQL
0 vote107 views1 answer
Openquery update linked server
SQL
0 vote97 views1 answer
Mysql workbench indent formatting
SQL
2 votes102 views2 answers
Oracle multiple insert
SQL
0 vote97 views1 answer
Oracle last character of string
SQL
0 vote105 views1 answer
Time in sql server
SQL
5 votes94 views1 answer
Mysql add user with all privileges
SQL
0 vote113 views1 answer
Mysql dump for selected row
SQL
0 vote96 views1 answer
Sql show all users
SQL
1 vote135 views2 answers
Install sql server management studio ubuntu
SQL