/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

3 votes97 views2 answers
Pl sql escape '
SQL
42 votes179 views6 answers
Install beautifulsoup
SQL
5 votes106 views1 answer
JBDC
SQL
0 vote114 views1 answer
Mysql installer did not find packages in the current bundle suitable for installation
SQL
19 votes112 views6 answers
What is mySQL
SQL
2 votes96 views1 answer
Sql to char function with date
SQL
0 vote102 views1 answer
Opensuse stop MySQL
SQL
3 votes115 views1 answer
Pl sql escape &
SQL
11 votes181 views1 answer
Oracle insert from select
SQL
0 vote120 views1 answer
Flexible search query delete table
SQL