在typeORM Typescript中使用LIKE in WHERE条件

import { getConnection } from 'typeorm';

async function searchUsers(keywords: string[], pattern: string): Promise<User[]> {
  const connection = getConnection();
  const queryBuilder = connection.createQueryBuilder(User, 'user');

  // 使用LIKE操作符进行模糊匹配
  queryBuilder.where('user.name LIKE :pattern', { pattern: `%${pattern}%` });

  // 使用IN操作符匹配多个值
  queryBuilder.andWhere('user.role IN (:...keywords)', { keywords });

  const users = await queryBuilder.getMany();
  return users;
}