On Tuesday 05 December 2006 01:19, Russ wrote:
Basically I have 2 tables that have no relationship. I want to search a
single field in table2 (somefield) by using every value from the
someotherfield field of the table1 table. I can't seem to get the syntax
quite right. Is this even possible
Does nobody have an idea on this? I'm basically trying to do something like
this:
select * from table1, table2 where table2.id=1 and table2.somefield like '%'
+ table1.someotherfield + '%'
This works fine, although it's a bit slow for my taste... is there a way to
optimize it, using full text
If you use CONTAINS, then full-text search will be used.
Russ
-Original Message-
From: Russ [mailto:[EMAIL PROTECTED]
Sent: 05 December 2006 15:31
To: CF-Talk
Subject: RE: Full-Text Query Help
Does nobody have an idea on this? I'm basically trying to do something like
this:
select
things a lot.
Is there a way to optimize SQL server to make like faster?
Russ
-Original Message-
From: Snake [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 05, 2006 10:40 AM
To: CF-Talk
Subject: RE: Full-Text Query Help
If you use CONTAINS, then full-text search will be used
4 matches
Mail list logo