/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 votes134 views2 answers
Sql random integer
SQL
0 vote88 views2 answers
Postgresql could not start server mac
SQL
12 votes136 views2 answers
Delete all entries postgres
SQL
0 vote145 views1 answer
Oracle execute immediate quotes
SQL
3 votes131 views1 answer
Oracle drop user
SQL
4 votes137 views3 answers
Count with where
SQL
-1 vote136 views1 answer
Su: Authentication failure mysql
SQL
1 vote124 views1 answer
How to open closed port mysql in ubuntu
SQL
2 votes144 views1 answer
Grant revoke privileges to mysql username
SQL
4 votes159 views2 answers
Convert utc to est sql
SQL