1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

search for partial words

Discussion in 'XenForo Pre-Sales Questions' started by videorecover, Aug 29, 2014.

  1. videorecover

    videorecover New Member


    Since I would buy xenforo to a domain name forum, I need search feature be able to match partial words, both in post title and it description.

    For example, if a post contains the "amazon.com" term, a search for "maz" must return the amazon post on search results. Anyway for begin, middle or end parts of text, as "amaz" or "zon" both must returns the amazon related post. As well a search for "zon.com" must return the same post.

    There is possible with default xenforo search capabilities, or if not, there is a plugin for that?

  2. Mike

    Mike XenForo Developer Staff Member

    You may be able to get away with "*maz*" but it would need to be added explicitly and I'm not sure it's guaranteed to work -- performance would be horrendous at the least. It's certainly not the default behavior so custom development would be needed to apply it automatically.
  3. FlameHiRo

    FlameHiRo New Member

    o-o I know I'm probably way off in saying this since I know zero of xenoforo's code. But I think the below query would do the trick.

    SELECT * FROM table where field like '%searched%'
  4. Brogan

    Brogan XenForo Moderator Staff Member

    Running a query won't help with regards to searches performed via the front end.
  5. videorecover

    videorecover New Member

    I just noticed the Wordpress search works with partial words by default.

    I know that it is a blog platform, not a forum system, but it is very interesting if xenforo could do something like that by default too.

Share This Page