/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 vote305 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote324 views1 answer
Sql include rows with 0 values
SQL
4 votes321 views1 answer
Is there any command to change postgres password
SQL
7 votes313 views1 answer
Postgres base size
SQL
3 votes328 views2 answers
Enter mysql command line
SQL
2 votes330 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote349 views1 answer
Select sql in descending order
SQL
3 votes327 views1 answer
Sql replace character in string in all records
SQL
3 votes371 views1 answer
Where id is in list sql
SQL
0 vote312 views1 answer
Sql how to display two atributes as one in sql
SQL