/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 vote198 views1 answer
Postgres get database encoding
SQL
0 vote205 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
0 vote199 views1 answer
Azure sql server check foreign key
SQL
0 vote206 views1 answer
Drop-toys-table
SQL
4 votes258 views2 answers
Sql display today's date
SQL
0 vote209 views1 answer
Java sql insert return id
SQL
0 vote217 views1 answer
Oracle current date minus 1 day
SQL
10 votes211 views5 answers
Create table mysql query
SQL
0 vote184 views1 answer
Drop specific row postgresql
SQL
0 vote222 views1 answer
Compress sql file database ubuntu
SQL