/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

2 votes124 views3 answers
Mysql pass command from command line
SQL
14 votes117 views5 answers
Set password for postgres user ubuntu
SQL
0 vote121 views1 answer
Mysql create index lost connection
SQL
3 votes127 views1 answer
Postgres add not null to existing column
SQL
1 vote146 views1 answer
How to get alternate records from a table in sql
SQL
5 votes123 views1 answer
Mysql where one year ago
SQL
0 vote130 views1 answer
Sql server for loop
SQL
1 vote121 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote119 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote273 views1 answer
What URL will take me directly to Rudolph's Reddit comment history?
SQL