0

I have a varchar column that contains the word clients. It is fulltext with clients data. I am failing to locate the row when searching by word client. I am hoping to avoid LIKE because of number of records. Is LIKE the only way to go? I read that WITH QUERY EXPANSION might help but the shared mysql server i am using does not recognize it.

Any tips?

user7366786
  • 11
  • 2
  • Possible duplicate of [Is there and alternative to LIKE statement in T-SQL?](http://stackoverflow.com/questions/26506879/is-there-and-alternative-to-like-statement-in-t-sql) – Oliver Frost Jan 15 '17 at 02:00
  • or http://stackoverflow.com/questions/7038590/alternative-to-like-clause-in-mysql – Oliver Frost Jan 15 '17 at 02:03
  • Possible duplicate of [Wildcard search in MySQL full-text search](http://stackoverflow.com/questions/20679696/wildcard-search-in-mysql-full-text-search) – Shadow Jan 15 '17 at 02:16

0 Answers0