Hope it is not too offtopic - Mailing list pgsql-general

Ok, here's my problem

I have a database of ISO standards ... my clients want to be able to do a full document search ... but it's not a document ... it's a database

Is there a way (more likely a query question) to select * from tablename where <anyfield> like '%term%'??

Thanks in advance

Eric