my query is

SELECT * FROM bollywood_films WHERE film_name LIKE '%love aaj kal%'

it only works when keyword is right..if i write "love ajj kal" then i found zero result.

i also try this

SELECT film_name FROM bollywood_films WHERE MATCH (film_name) AGAINST ('love aaj kal')

this query is not working.. my column type is varchar(255)

this error is shows in phpmyadmin

"#1214 - The used table type doesn't support FULLTEXT indexes"

help me if you know or provide my search query

Thanks