Fuzzy Search with SQL

fuzzySearch.sql

// Serach for SANDRA across multiple tables and columns
SELECT * FROM (
	SELECT *,
  	(
	  CASE
	 	WHEN first_name LIKE '%SANDRA%' THEN 1 
	 	ELSE 0
	  END
	) AS match_strength
  FROM actor
  UNION ALL
  SELECT *, 
  (
  	CASE
	WHEN first_name like '%SANDRA%' THEN 1
	ELSE 0
	END
  )as match_strength
 FROM actor_tv
) 
AS x
WHERE match_strength > 0
ORDER BY match_strength DESC;