How do you build up a LIKE condition in a db_select() query?
After digging through Drupal Documentation found a solution in db_like API documentation page and SelectQuery:condition handler doc page..

For example

$result = db_select('field_data_field_name', 'f')-&gt;fields('f', array(
    'entity_id',
    'field_name_value'
))
-&gt;condition('entity_type', 'user')
-&gt;condition('bundle', 'user')
-&gt;condition('deleted', 0)
-&gt;condition('field_name_value', '%' . db_like($last_item) . '%', 'LIKE')
-&gt;distinct()
-&gt;range(0, 10)
-&gt;execute();


Condition to use for like query is 

-&gt;condition('field_name_value', '%' . db_like($last_item) . '%', 'LIKE')