jimbobmcgee (12/3/2012)

---

I'm not sure why you need the * here.

* is supposed to be a prefixing term, so "ipad*" should match words that start with "ipad", e.g. "ipady", "ipadness", "ipadable"...

Eugene Elutin (11/19/2012)

---

eranzo111 (11/19/2012)

---

A dead end I guess... 🙁

I was so happy when I saw the significant performence improvement when I used the full text search instead of the...

A dead end I guess... 🙁

I was so happy when I saw the significant performence improvement when I used the full text search instead of the LIKE query, and...

Tava (11/19/2012)

---

eranzo111 (11/19/2012)

---

Hi Tava,

With those 2 queries, I get partial results.

Let say the the text I query by is "eran":

SELECT *

FROM table_name

WHERE FREETEXT(*, 'eran');

SELECT *

FROM table_name

WHERE CONTAINS(field_name, 'eran');

And the DB...

Hi Tava,

With those 2 queries, I get partial results.

Let say the the text I query by is "eran":

SELECT *

FROM table_name

WHERE FREETEXT(*, 'eran');

SELECT *

FROM table_name

WHERE CONTAINS(field_name, 'eran');

And the DB has 4...