/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 vote268 views1 answer
Adding a default constraint to an existing column in sql
SQL
4 votes281 views4 answers
Print pl sql
SQL
2 votes272 views1 answer
Apex execute batch job
SQL
1 vote276 views1 answer
Mysql view current queries
SQL
0 vote279 views1 answer
Select all columns except one sql
SQL
20 votes288 views3 answers
How to open postgresql in mac
SQL
2 votes232 views2 answers
Mysql get last character of string
SQL
0 vote311 views2 answers
How to drop mili second in sql
SQL
0 vote270 views1 answer
Mariadb used space
SQL
1 vote277 views1 answer
Increase existing date in sql oracle
SQL