I have the task to query data from my phpMyAdmin database and also to query the emails from each webform 'to_email' field. Is there a way to query that data using MySql? I was able to do it using php, but I can't seem to find a way to access the webform email settings by using only MySql.

Edit: I just found out that all the website data is stocated in the database. For example, you can find the data in your 'to_email' field inside your node.type. row, in a blob.

1 Answer 1


Yes, it is possible. you can try the following query to find all entries in 'cache_config' that contain 'to_email':

SELECT cid, data
FROM cache_config
WHERE data LIKE '%to_mail%'

This will get you all the blobs that contain the given field. Even more than that, you can look for what follows 'to_mail' to get the actual mail by using the LOCATE and SUBSTRING functions.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.