/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

0 vote188 views1 answer
Install ms sql server management studio
SQL
1 vote201 views1 answer
Print all records of table in mysql
SQL
1 vote207 views1 answer
Postgres set sequence value to max id
SQL
0 vote175 views2 answers
Change database postgres
SQL
1 vote194 views1 answer
How to use db.execute
SQL
0 vote216 views2 answers
Clauses in mysql
SQL
0 vote191 views1 answer
Display first three characters sql
SQL
0 vote201 views1 answer
Find usage of table in sql server
SQL
0 vote196 views1 answer
Alter boolean column postgresql
SQL
13 votes206 views5 answers
Sql default
SQL