在typo3中使用LIKE and OR进行模式匹配的语法

plugin.tx_myextension {
  query {
    selectFields = *
    tableName = tx_myextension_domain_model_table
    where = field1 LIKE 'value1' OR field2 LIKE 'value2'
  }
}

$queryBuilder = \TYPO3\CMS\Core\Utility\GeneralUtility::makeInstance(\TYPO3\CMS\Core\Database\ConnectionPool::class)
  ->getQueryBuilderForTable('tx_myextension_domain_model_table');

$query = $queryBuilder
  ->select('*')
  ->from('tx_myextension_domain_model_table')
  ->where(
    $queryBuilder->expr()->orX(
      $queryBuilder->expr()->like('field1', $queryBuilder->createNamedParameter('value1')),
      $queryBuilder->expr()->like('field2', $queryBuilder->createNamedParameter('value2'))
    )
  )
  ->execute();

$result = $query->fetchAll();