CODEWITHSUNDEEP
mysqlmatch-against
Deepa
Deepa

Reputation: 1301

end with query using match against in mysql

i want to retrieve those state that end with 'than' using match agianst in mysql query. i used the following query

SELECT * FROM yp WHERE MATCH (state) AGAINST ('*than' IN BOOLEAN MODE)

but it return and empty set of result.can anyone tell me what is the exact query?

Upvotes: 0

Views: 504

Answers (1)

Sakthi
Sakthi

Reputation: 363

SELECT * FROM yp WHERE state LIKE '%than'

this query will return only those state are end up with 'than'. I think this may helps U..

Upvotes: 2

Related Questions