What do you want to save?
Add Code snippet
New code examples
-
SQL 2021-09-23 09:38:05
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 )... Add solution