LIKE operator to load taxonomy term

Question

I want to retrieve a taxonomy term using this line:

$term = $this->entityTypeManager->getStorage('taxonomy_term')
        ->loadByProperties(['myfield' => 'mytext']);

How can I rather use the 'LIKE' operator we have in SQL, so that in case the 'myfield' contains a text and not a string in the database, it still works? Thanks for your help

Answer 1

I found the answer..I had to use the entity query then load term:

$result = \Drupal::entityQuery('taxonomy_term')
        ->condition('myfield', 'mytext', 'LIKE')
        ->execute();

$term = \Drupal::entityTypeManager()
        ->getStorage('taxonomy_term')
        ->loadMultiple($result);