How to use the LIKE operator with partial word matching?

Asked Nov 18 '21 at 13:43

Active Nov 18 '21 at 14:39

Viewed 23 times

How can I have I want to eat rice match I wan to eat ric? The issue is the wan portion.

DB:

dialogue          | category
                  |
Want to eat rice  | food

SQL:

SELECT category FROM `categories` WHERE dialogue LIKE '%I wan to eat ric%'

This returns no results. It should return food.

edited Nov 18 '21 at 14:39

user3783243

asked Nov 18 '21 at 13:43

Chris

Which dbms are you using? – jarlh Nov 18 '21 at 13:48
Does this answer your question? https://stackoverflow.com/questions/634995/implementation-of-levenshtein-distance-for-mysql-fuzzy-search – Justinas Nov 18 '21 at 13:49
@jarlh I'm using MYSQL – Chris Nov 18 '21 at 13:50

0 Answers0