/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

40 votes276 views4 answers
PostgreSQL add column
SQL
3 votes223 views1 answer
Oracle apex message quit website
SQL
2 votes260 views2 answers
How to run postgresql in linux
SQL
2 votes243 views1 answer
Scaffold npgsql net core
SQL
0 vote245 views1 answer
Case when with count and combining similar values in sql
SQL
0 vote243 views1 answer
Drop CHECK constraint sql
SQL
1 vote201 views1 answer
Unique vs distinct sql
SQL
3 votes226 views1 answer
Index using in query plsql
SQL
1 vote248 views3 answers
Execute sp in sql server
SQL
4 votes219 views1 answer
To date oracle with time
SQL