How to do nested AND OR with query builder

[guoyunhe]

For example, I want to search "hello world" from posts:

SELECT * FROM posts
WHERE (title LIKE '%hello%' OR content LIKE '%hello%')
AND (title LIKE '%world%' OR content LIKE '%world%');

How to achieve this with Adonis' query builder?

[guoyunhe]

Found this solution, using where groups

search.split(' ').forEach((word) => {
  query.where((q) => {
    q.whereILike('title', `%${word}%`).orWhereILike('content', `%${word}%`);
  });
});