Results 1 to 4 of 4
Thread: help in good search query
Mar 27, 2012, 14:48 #1
- Join Date
- Jul 2011
- 0 Post(s)
- 0 Thread(s)
help in good search query
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