-
Problem searching strings
Hi everybody!
I have a table like this:
Create table t
(
id int
texto varchar(400)
)
And this table have around 1000000 rows. I want to be enable to make the next query in few seconds:
Select * From T
where
texto like %palabra%
Some idea how can I replace the like for something else. Something importan, I can't use full-index.
Thank you.
Zoraya
-
Problem searching strings (reply)
only fulltext index.
------------
Zoraya at 5/14/01 8:32:04 AM
Hi everybody!
I have a table like this:
Create table t
(
id int
texto varchar(400)
)
And this table have around 1000000 rows. I want to be enable to make the next query in few seconds:
Select * From T
where
texto like %palabra%
Some idea how can I replace the like for something else. Something importan, I can't use full-index.
Thank you.
Zoraya
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|