/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

4 votes211 views1 answer
Wilayah indonesia database
SQL
0 vote235 views1 answer
Connect by query in oracle
SQL
0 vote245 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote235 views1 answer
Close sql query vb.net
SQL
16 votes240 views6 answers
Install sqlite3 python
SQL
7 votes262 views5 answers
Max 3 salary in sql
SQL
0 vote248 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL
1 vote235 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote238 views1 answer
Mysql timediff
SQL
0 vote211 views1 answer
Pl sql turn off variable substitution
SQL