/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 vote147 views1 answer
Date 3 months from today sql
SQL
0 vote139 views1 answer
Pl/ sql change currency
SQL
0 vote146 views1 answer
Sql statement show all emails with dome
SQL
0 vote157 views3 answers
Mysql keyword search
SQL
0 vote123 views1 answer
Concat column value of same user in mysql
SQL
24 votes147 views6 answers
Alter table name sql
SQL
0 vote140 views1 answer
Postgresql get diff between two dates in Months
SQL
0 vote139 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
-1 vote163 views4 answers
Postgres between dates
SQL
0 vote150 views1 answer
Check the size of the tables here ordered from the biggest size
SQL