Check out example codes for "sql query to get contact form 7 fields". It will help you in understanding the concepts better.

Code Example 1

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
form_name = 'Purchases'
GROUP BY submit_time
ORDER BY submit_time DESC

Learn ReactJs, React Native from