raulingg · August 17, 2018 22:31
diff --git a/MYSL JSON_CONTAINS example b/MYSL JSON_CONTAINS example
 select 
    id, name 
  from 
    courses 
  where 
    name like "%Gabriel%"
    or (JSON_EXTRACT(lessons, "$[*].name") like "%Gabriel%")
    or (JSON_EXTRACT(lessons, "$[*].subjects[*].name") like "%Gabriel%");
	select
	id, name
	from
	courses
	where
	name like "%Gabriel%"
	or (JSON_EXTRACT(lessons, "$[*].name") like "%Gabriel%")
	or (JSON_EXTRACT(lessons, "$[].subjects[].name") like "%Gabriel%");