/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 vote90 views1 answer
Split a string with expression and get the last value of split sql
SQL
0 vote127 views1 answer
Do postgresql
SQL
-1 vote137 views1 answer
Concat two columns in sql server
SQL
-1 vote183 views1 answer
Get month and year from date in mysql sequelize
SQL
1 vote142 views1 answer
How to print longest name in sql
SQL
1 vote122 views1 answer
Import local sql into remote mysql
SQL
6 votes124 views2 answers
Oracle undotbs usage
SQL
0 vote125 views1 answer
Automate mysql cli query
SQL
8 votes160 views1 answer
Insert a select statement into a table
SQL
15 votes117 views4 answers
T-sql drop function if exists
SQL