how to search a specific keyword from mysql database

Question

here my table looks like

course{
id,title,description,instructor}

i was trying to match a word from description

this is what i have tried

SELECT * FROM course WHERE MATCH (description) AGAINST ('java' IN BOOLEAN MODE);

got this error Can't find FULLTEXT index matching the column list

`MATCH .. AGAINST` can be applied only when you have created fulltext index previously. Do it. Or use common searching via string functions. — Akina, Mar 19 '20 at 08:35
Does this answer your question? [MySQL FULLTEXT indexes issue](https://stackoverflow.com/questions/963534/mysql-fulltext-indexes-issue) — Reza Ahmadi, Mar 19 '20 at 08:35

score 0 · Answer 1 · answered Mar 19 '20 at 08:37

0

I think that you could use this:

SELECT * FROM course WHERE description LIKE '%java%'

answered Mar 19 '20 at 08:37

besartm

1 Answers1