Using the Search Function in Google BigQuery | by Christianlauer | CodeX | Medium

SELECT
  SEARCH(column, 'search text') AS x, #one column
  SEARCH((column_1, column_2), 'search text') AS y, #multiple columns
  SEARCH(table, 'search text') AS z #table scan
FROM table;