Search Multiple keywords across multiple fields

Similar Threads:

1.searching across multiple fields

I have a query designed to search multiple fields for any word that
starts with the characters entered in a search. Each field will
typically contain more than one word. The query takes the form:

SELECT
field1, field2
FROM table1 WHERE ((field1 LIKE "a%") OR (field1 LIKE "% a%") OR (
field2 LIKE "a%") OR (field2 LIKE "% a%"))

Is there a more efficient way to search than this?

Michael

2.Multiple fields with multiple search items

Hello everyone:  I am having a bit of a problem trying to wrap my head
around a particular select statement... I have a table that has
numerous stores.  Beyond the normal address, city, state, zip fields,
each store record has 5 fields, 1 for each for ice cream flavor
carried at that particular store.  I have a search box that lets you
search for ice cream flavors.  Right now searching for one flavor is
hard enough since my select statement select all records "where
flavor1 = "x" or flavor2 = 'x' or...", but I would like the ability to
search for multiple flavors, and have the returned results start with
those stores that match the most flavors searched upon.  Does anyone
have any way of doing this?  Also, the page is written in PHP so if
you have any php related way to handle this issue, I am more than
happy to try them as well.  Thank you!!!

3.Multiple Keyword Search using SQL PROC

I need to support multiple keyword search, not boolean searchs, just simple 
searches, i.e. "marhsall ma". How is this done? Do I send the entire search 
string to the Proc? How do I deal with it there? I'm thinking I need to 
build the WHERE clause in the code behind and send it to the proc. What do 
you think?

Thanks,

David Lozzi 

4.Full-text search across multiple tables

Hello,

We are developing an application against an MS SQL Server 2000 database
which requires that we implement full-text searching across columns in
multiple tables.  The research that we have conducted seems to indicate
that this is not directly possible within SQL Server 2000.  And we can
find no way to implement this as the catalogs that are generated are
table specific.

As a work-around, we are planning to create a secondary table used
strictly for searching which is going to denormalize and combine the
searchable data into one catalog.  We just want to confirm that this is
the recommended approach or if there is an alternate solution anyone
has used.  Please note that upgrading to SQL Server 2005 is not an
option.

Thanks.

John Fleming
 XXXX@XXXXX.COM 

5.Full Text Search across multiple tabels in SQL 2005/2008

We have a requirement where we need to do full text search for a given string 
across multiple unrelated tables in the DB.
The number of tables is quite large, and hence we can't use a UNION of 
results on all tables. Also, this won't give us the right ranking.

The one option that I could think of involves creating a new de-normalized 
table containing the columns from tables we want to index(with other related 
data). Then I can create a Full Text Index on columns of this table, and 
perform search queries on this. But this would mean, that I'll have the 
overhead of maintaining this table in sync with creates and updates on the 
tables involved.

Is there any other way to accomplish this in SQL 2005/2008? 

6. Full Text Search across multiple tables (Parent-Child)

7. Search across multiple columns

8. searching across multiple columns