/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 vote187 views2 answers
Full join
SQL
3 votes181 views2 answers
See mysql users ubuntu
SQL
2 votes168 views1 answer
Oracle sql drop column if exists
SQL
0 vote165 views1 answer
How to to get current date in sql
SQL
4 votes170 views2 answers
Oracle default date format
SQL
1 vote187 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
1 vote162 views4 answers
Psql check tables command
SQL
0 vote156 views1 answer
Mysql workbench indent formatting
SQL
0 vote222 views1 answer
Postgresql print variable
SQL
0 vote175 views1 answer
Cannot pip install mysqlclient
SQL