Jump to content


Photo

Full text search -


  • Please log in to reply
No replies to this topic

#1 MicroShaft

MicroShaft
  • Members
  • Pip
  • Newbie
  • 4 posts
  • LocationStoke on Trent (I know but someone has to live there)

Posted 30 November 2005 - 03:49 AM

Ive been reading up on full text search and gone throught the tutorial on this site.
Read in many places the FTS is better and faster than a LIKE when dealing with a lot of records.


Im tryin to create a search which show all rows which has the word smith in when they search for smith

for example

smith
coppersmith
blacksmith
smithson

currently the full text search works for smith fine when only searching for smith. The only way i could make it show all the other words is by tagging OR fieldname LIKE '%smith%' on the end

Am i doing this right or is there another way of doing this.

ive also realised if i want to do a full text search on two tables (one field from each) on a inner join its faster using the boolean. can someone confirm this


Thanks




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users