/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 vote341 views1 answer
Mysql select month and year
SQL
0 vote396 views1 answer
Mysql grant all on all databases
SQL
9 votes333 views2 answers
Get first 3 letters in sql
SQL
13 votes346 views5 answers
Sql default
SQL
0 vote335 views1 answer
How to find unique key in sql
SQL
3 votes356 views1 answer
Select database in sql
SQL
0 vote340 views1 answer
Java spring boot connect to sql server
SQL
0 vote352 views1 answer
SQL Server Altering Column to be Unique
SQL
10 votes352 views4 answers
Mysql one week ago
SQL
1 vote345 views1 answer
Pv mysql import
SQL