like %TEXT% in full text search

Asked

Viewed 132 times

1

I would like some help regarding the search using full text search in SQL Server. Today I have a table that stores materials and I’m doing a search using full text search with contains getting like this

SELECT * FROM MATERIAL WHERE CONTAINS(MAT_D040I1, '"FUSO*"' )

With this query will bring all the materials you have started by FUSO for example

FUSO MEITECH EVA20048 TRAY SPLICE JG 24 MERGERS

but I would like to do a research that does not only bring the initiated by and rather contains in the middle of the word (like)

SELECT * FROM MATERIAL WHERE MAT_D040I1 like '%FUSO%'

with this in addition to bringing the materials FUSO MEITECH EVA20048 and TRAY SPLICING JG 24 FUSOES would bring SCREW SETTING DII 2A RS and SCREW SXT S/ENC MA 4X30MM

it would be like doing something like this with full text search instead of like???

If you have any doubts, please inform me.

  • It’s not just putting the * also on the other side of the word ?

  • Not rsrs tested but does not work, so I read the advantage of full text search is the use of index, if allow a joker at the beginning would not have to use the indexing, but I was wondering if there is another way to solve this

No answers

Browser other questions tagged

You are not signed in. Login or sign up in order to post.