/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 vote260 views1 answer
Oracle gather table statistics
SQL
0 vote265 views1 answer
Java spring boot connect to sql server
SQL
5 votes258 views1 answer
Oracle sysdate
SQL
3 votes275 views1 answer
Async await mysql nodejs
SQL
0 vote261 views2 answers
Update Query in SQL Server Table - NAYCode.com
SQL
0 vote255 views1 answer
Oracle job class
SQL
0 vote266 views1 answer
Mysql dump everythign
SQL
0 vote269 views1 answer
Sqlite to csv statement
SQL
1 vote276 views1 answer
Sql first day quarter
SQL
0 vote252 views1 answer
Postgres 11 add primary key
SQL