How to write a WHERE clause with the '=' operator using db_select()? I have MySQL query as:

SELECT *
FROM `field_revision_field_innostream_state`
WHERE `field_innostream_state_tid` =187
LIMIT 0 , 30


How to write a WHERE condition within db_select?
db_select('field_revision_field_innostream_state', 'innostream')
  -&gt;fields('innostream')
  -&gt;condition('innostream.field_innostream_state_tid', 187, '=')
  -&gt;range(0,30)
  -&gt;execute()
  -&gt;fetchAssoc();