General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2000
Is there any performance concerns when issuing the following query on a text field in a SQL Server table?
SELECT * FROM mytable where myfield LIKE '%mykeyword%'
or
SELECT * FROM mytable where myfield LIKE '%key1%' or myfield LIKE '%key2%'
I would like to give my users keyword search lookups and I am trying to find the best possible solution.
Thanks,
Jerry
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only