The brute force Drupal 9 content query
While this might be apparent to many, here is a brute force method to search a drupal 9 for the Body field for any matches of a string. I am not a Drupal expert, so finding the table + field was a bit of a chore.
The SQL query selects all columns (*) from the
node__body table where the post code lives. The
% symbol is a wildcard operator in SQL and is used to match any number of characters before or after a specified pattern. Be sure to surround your query with the
%. For example, if searching for "Hello World!", it would be
%Hello World!%. You can search for HTML within the individual fields as well.
Of course this can easily search multiple entires by using AND.
Using a GUI like Sequel Ace, you should be to see which bundle it's in, if you've set up different page types, and the
entry_id which can, of course, be accessed via PHP or simply by going to sitename.com/node/entry_id or sitename.com/node/entry_id/edit to get directly to the admin "edit" panel for the node.