/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

7 votes205 views1 answer
Mysql unsafe update
SQL
1 vote229 views1 answer
Mysql datetime with timezone offset
SQL
0 vote225 views1 answer
Sql show table name in result
SQL
11 votes228 views4 answers
Update row in mysql
SQL
2 votes222 views1 answer
Drop all database tables oracle sql developer
SQL
0 vote240 views2 answers
How to truncate all table in mysql workbench
SQL
0 vote221 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL
6 votes206 views1 answer
Postgresql get year
SQL
2 votes235 views5 answers
Install postgresql 10 centos 7
SQL
1 vote199 views1 answer
Mysql select row with max value group by
SQL