/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 vote325 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote324 views2 answers
How to relationship query two different tables in MySQL
SQL
0 vote323 views1 answer
Order by ip address sql
SQL
0 vote335 views1 answer
Mysql timediff
SQL
2 votes309 views1 answer
Mysql sysdate
SQL
14 votes380 views5 answers
Set password for postgres user ubuntu
SQL
0 vote356 views1 answer
Convert multiple columns to ROws in sql server
SQL
4 votes359 views1 answer
List tables sqlite
SQL
0 vote342 views1 answer
Copy value from one column to another postgres
SQL
0 vote324 views1 answer
Write sql query to show the details start from digit
SQL