I have increasingly been asked to search existing content on the website for custom text or links. Unfortunately, each of the possible fields a user could have put text is a separate table, each with different schemas. This means writing a separate SQL query for each possible place the text could be hiding.
As we haven't added new fields in a long time, this list (while very long) is finite. That means I should take the time to write the queries into a single "content search" script for future use.
I have increasingly been asked to search existing content on the website for custom text or links. Unfortunately, each of the possible fields a user could have put text is a separate table, each with different schemas. This means writing a separate SQL query for each possible place the text could be hiding.
As we haven't added new fields in a long time, this list (while very long) is finite. That means I should take the time to write the queries into a single "content search" script for future use.