/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 vote292 views2 answers
PostgreSQL having
SQL
0 vote293 views1 answer
Mac os zsh: command not found: mysql
SQL
0 vote287 views1 answer
Oracle string substitution
SQL
0 vote299 views1 answer
Sql script get all stored procedures from database
SQL
0 vote315 views1 answer
Creating h2 database in relative directory eclopse
SQL
4 votes276 views2 answers
Error loading MySQLdb module.
SQL
1 vote310 views1 answer
Sqlalchemy order by descending
SQL
1 vote281 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception table not found
SQL
3 votes294 views2 answers
How to load files in mysql
SQL
16 votes293 views3 answers
Tsql rename column name
SQL