/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

1 vote98 views3 answers
Mariadb add foreign key
SQL
0 vote98 views1 answer
Hive batch drop table
SQL
0 vote121 views1 answer
Sql last time database was accessed
SQL
0 vote47 views1 answer
FindAllBy
SQL
2 votes88 views1 answer
Ifnull postgres
SQL
0 vote102 views1 answer
PostgreSQL types and C# types
SQL
0 vote102 views1 answer
Can we rollback deleted data in sql
SQL
7 votes110 views5 answers
Max 3 salary in sql
SQL
0 vote249 views2 answers
Https://cloud.google.com/shell/docs/using-web-preview#previewing_the_application
SQL
0 vote113 views1 answer
How to get nth number in sql
SQL