/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 vote332 views1 answer
How to take sum of column with same id in "JPQL?"
SQL
0 vote300 views1 answer
Mariadb used space
SQL
0 vote319 views1 answer
Longtext sql
SQL
0 vote311 views1 answer
Oracle sql log to console
SQL
0 vote340 views1 answer
Error: SAP DBTech JDBC: [258]: insufficient privilege: Detailed info for this error can be found with guid '87813FAA56439F48BD60812F3EBEC5A4'
SQL
0 vote320 views1 answer
Change magento database url usimg musql
SQL
0 vote305 views1 answer
C# check if mysql query modified rows
SQL
0 vote284 views1 answer
How to see the query of a view in mysql
SQL
5 votes364 views1 answer
Mysql where one year ago
SQL
1 vote350 views1 answer
Oracle see column type
SQL