/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 vote176 views3 answers
Remove folders from remote git
SQL
2 votes163 views3 answers
Mysql unix timestamp to date
SQL
0 vote163 views1 answer
Online sql testing tool
SQL
2 votes219 views3 answers
Sql server reseed identity column
SQL
4 votes172 views2 answers
Oracle unlock user
SQL
2 votes178 views1 answer
Q operator in oracle
SQL
0 vote186 views1 answer
Product of a column in mysql
SQL
-1 vote176 views1 answer
How to dump .csv file into mysql
SQL
1 vote193 views1 answer
Postgresql not in
SQL
0 vote167 views1 answer
Python mysql query where
SQL