SQL Query Search

Question

I need to search ALL projects for a particular strings (there are too many to use the GUI) - I have access to the backend SQL DB but i am struggling to find where the project descriptions and summaries are stored in the schema.

I am not looking for anything complicated, I just want to be able to search for these keywords and if found show me them

Payne · Answer

Have you looked at the project table? Something like

select * from project where pname like '%text%' or description like '%text%'

That seems like too easy an answer, so perhaps what you're trying to do is more complex than this.