The most effective method to utilize LIKE condition in information base question on Drupal 8 ?
The like condition linguistic structure is:
$query->condition('field_name', "%" . $query->escapeLike("The string") . "%", 'LIKE');
$string="search string";
$connection = \Drupal\Core\Database\Database::getConnection();
$query = $connection->select('table_name', 't')
->fields('t', ['field_1', 'field_2']);
$query->condition('field_1', "%" . $query->escapeLike($string) . "%", 'LIKE');
$result = $query->execute()->fetchAll();