/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

6 votes203 views2 answers
Mysql first day of month
SQL
0 vote204 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
17 votes207 views3 answers
Postgresql version command
SQL
1 vote240 views1 answer
Mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists.
SQL
23 votes210 views4 answers
How to uninstall postgresql in ubuntu
SQL
19 votes230 views5 answers
Display table in sql
SQL
0 vote201 views1 answer
Mysql repair a table
SQL
0 vote264 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
1 vote233 views1 answer
Liquibase alter column type / length
SQL
1 vote210 views3 answers
Getdate function in postgresql
SQL