/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 vote345 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL
0 vote382 views2 answers
Sql auto update dupdated_at
SQL
12 votes366 views1 answer
Docker mysql random root password
SQL
1 vote365 views1 answer
Launch sql script from docker in mysql
SQL
1 vote345 views1 answer
Count of tables in database mysql
SQL
0 vote432 views1 answer
Split first name and last name in sql
SQL
3 votes310 views2 answers
Mysql sum with condition
SQL
3 votes358 views1 answer
Dbms_scheduler drop_job
SQL
1 vote360 views2 answers
Sql drop multiple columns if exists
SQL
13 votes357 views6 answers
Restart postgresql
SQL