0

How can i set mysql select to treat words without single quote same as if i searched them with single quote. for example if i'm searching for dont treat it like don't

What I've tried

MATCH(title,short_story,full_story,dle_post.xfields) AGAINST ('dont') order by MATCH (title) AGAINST ('dont' IN NATURAL LANGUAGE MODE WITH QUERY EXPANSION) desc LIMIT 0,22
rabotalius
  • 1,430
  • 5
  • 18
  • 27

1 Answers1

-1

I think this is in relation to your issue

Full text query with a single quote

I am almost certain dont or don't is a stopword.

Community
  • 1
  • 1
Mad Dog Tannen
  • 7,129
  • 5
  • 31
  • 55