Create an explicit full-text search condition (alias for natural language mode) SQL: MATCH(columns) AGAINST(searchTerm IN NATURAL LANGUAGE MODE)
import { matchFulltext } from 'orm';Article.findAll({ where: { [matchFulltext(['title', 'body'])]: 'database' }})// SQL: WHERE MATCH(title, body) AGAINST('database' IN NATURAL LANGUAGE MODE) Copy
import { matchFulltext } from 'orm';Article.findAll({ where: { [matchFulltext(['title', 'body'])]: 'database' }})// SQL: WHERE MATCH(title, body) AGAINST('database' IN NATURAL LANGUAGE MODE)
Create an explicit full-text search condition (alias for natural language mode) SQL: MATCH(columns) AGAINST(searchTerm IN NATURAL LANGUAGE MODE)