How do you build up a LIKE condition in Drupal 8

The like condition linguistic structure is:

$query->condition('field_name', "%" . $query->escapeLike("The string") . "%", 'LIKE');

You might also like

edit post

Why Should You Leave Drupal 7 and Go with Drupal 9

April 1, 2023

edit post

Migration from Drupal 7 to Drupal 10

March 12, 2023

$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();

Reference