/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 vote246 views1 answer
Html css mobile menu arrow dropdown
SQL
8 votes268 views1 answer
Oracle tablespace datafile max size
SQL
2 votes262 views2 answers
How to view created temporary tables in mysql
SQL
-1 vote273 views3 answers
SQL MM/dd/yyyy format
SQL
1 vote278 views1 answer
Error code 1292 mysql workbench
SQL
0 vote276 views1 answer
Sqlite explain plan
SQL
1 vote268 views1 answer
Sql current timestamp
SQL
1 vote269 views1 answer
Drop df constraint sql server
SQL
2 votes268 views1 answer
Grant revoke privileges to mysql username
SQL
0 vote297 views1 answer
Sql constarint
SQL