/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

4 votes186 views3 answers
Sql find second highest salary employee
SQL
0 vote184 views1 answer
Allow null in psql
SQL
0 vote182 views1 answer
Mysql insert multiple rows based on select
SQL
0 vote181 views1 answer
How to create a new shema using query languaage
SQL
0 vote192 views1 answer
Drop a view in sqlite
SQL
0 vote175 views1 answer
Create a sql server database programmatically
SQL
0 vote187 views1 answer
T-sql email validation
SQL
8 votes183 views1 answer
Oracle tablespace datafile max size
SQL
0 vote155 views1 answer
Rollback to name in sql
SQL
0 vote221 views1 answer
Copy from one table to another postgres using matching column
SQL