/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 vote276 views1 answer
Window function mysql
SQL
0 vote282 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
0 vote258 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
13 votes215 views2 answers
Oracle all source
SQL
2 votes263 views3 answers
Row number mssql
SQL
2 votes269 views2 answers
Created at and updated at in mysql
SQL
0 vote275 views1 answer
Search mysql database for column
SQL
0 vote268 views2 answers
Postgres having
SQL
2 votes290 views2 answers
Postgres timestamp to datetime
SQL
6 votes263 views4 answers
How to remove unique key in mysql
SQL