CODEWITHSUNDEEP
mysqlstringmatchmatch-against
erol cimen
erol cimen

Reputation: 11

Using MATCH(FILTER) AGAINST with LIKE mysql

i will try to describe my question as simple as possible

i have a table called FILTERS with 2 columns 'Filter' and 'ID'

this table is populated like below example

|_. Filter |_. ID|
| shoes| 1|
| black shoe| 0|
| bot shoe| 3|
| bots | 2|

and

search string is ' i am looking for shoes and bots '

SELECT * from Filters WHERE match(Filter) AGAINST ('i am looking for shoes and bots')

getting nothing as a query result...but i want to get the query result ID 3 which filter column contains bot shoe

when i change the search string to 'i am looking for shoe and bot'

i get id 3 and 0

i tried to add IN BOOLEAN MODE and '+' for each words i am searching ... didnt help though

SELECT * from Filters WHERE match(Filter) AGAINST ('i am looking for +shoes and +bots' IN BOOLEAN MODE)

Upvotes: 0

Views: 53

Answers (0)

Related Questions