/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

1 vote157 views3 answers
How to get date in sql
SQL
0 vote158 views1 answer
Resullt all update knex mysql
SQL
0 vote155 views1 answer
How to know if table in rigt or left in sql
SQL
22 votes182 views3 answers
Sql cheat sheet
SQL
1 vote167 views1 answer
Sqlstate[imssp]: the active result for the query contains no fields.
SQL
0 vote156 views1 answer
We are intrested to work with your organization
SQL
3 votes167 views1 answer
Convert sqlite table to pandas dataframe
SQL
1 vote167 views3 answers
How to reset id column in sql server
SQL
0 vote152 views1 answer
Codeigniter 3 get best-selling products
SQL
1 vote146 views2 answers
Mysql allow remote connections
SQL