I did search and saw a similar Where (what directory) are the default Wordpress Widget Codes stored? but this is not my question.
When I have a lot of widgets configured, say a few dozen RSS feeds each in its own widget, where exactly is this data stored? I'd like to be able to copy this data to import into another theme using the same plugin/widget without needing to retype all the urls fed into the rss widgets.
Update - it seems this request is looking to solve an issue at the wrong level. Elsewhere, I was advised to just use a plugin, Widget Importer & Exporter and it preserved the widget settings very well. No need to mess with the source or SQL.
LIKE %..%for "widget"