regex.sql

SELECT 
  business.name, 
  business.full_address, 
  business.city, 
  business.state, 
  review.text, 
  review."date" AS "date", 
  review.user_id AS user_id, 
  review.stars AS stars, 
  review.text AS text
FROM 
  elastic.yelp.business AS business
INNER JOIN 
  elastic.yelp.review AS review ON business.business_id = review.business_id
WHERE CONTAINS(text:'/joh?n(ath[oa]n)/ -john -michael')