This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

  1. Forum
  2. FormTools Support
  3. Help on finding similar data in the database table
pwtan14262
pwtan14262

Hi all,

I would like to know how can i find data that is similar to each other. I have tried the command " select * from

where match (question) against ('library' in NATURAL LANGUAGE MODE)" but it return "ERROR 1214 (HY000): The used table type doesn't support FULLTEXT indexes" I'm wondering is there an October CMS/Laravel way of achieving the the following results?

Example: Database table: | id | question | | 1 | What is a library | | 2 | Where is the library | | 3 | How to go shopping mall |

Return result: | id | question | | 1 | What is a library | | 2 | Where is the library |

Thanks in advance

1-1 of 1

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.