/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 vote265 views1 answer
Xampp import sql file command line
SQL
-1 vote285 views5 answers
Convert sql to linq query online
SQL
0 vote265 views1 answer
Unique index in mysql
SQL
0 vote297 views1 answer
What logs are available on RDS MySQL?
SQL
2 votes294 views1 answer
Sql server find columns list in tables
SQL
0 vote296 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote267 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
0 vote267 views1 answer
C# check if mysql query modified rows
SQL
0 vote271 views1 answer
Knex last insert id mysql
SQL
0 vote302 views1 answer
Mysql faster delete
SQL