charlesonthego
Programmer
I need to search in a 'text' field (the field is a product description, it has around 4000 characters).
1. What is the best way to do this without using Full Text Search features? I have one or two keywords to search for in the 'description' field only. I have around 2000 records in the table, each record has around 4000 characters in the 'description' field. I simply need to find all the records with a match.
2. If I am going to use FUll Text Search features, what is the syntax for creating the full text search index on the existing database so that the full text search commands will work?
Charles
1. What is the best way to do this without using Full Text Search features? I have one or two keywords to search for in the 'description' field only. I have around 2000 records in the table, each record has around 4000 characters in the 'description' field. I simply need to find all the records with a match.
2. If I am going to use FUll Text Search features, what is the syntax for creating the full text search index on the existing database so that the full text search commands will work?
Charles