Tutorial by Topics: extract

val extractor(extractedValue1, _ /* ignored second extracted value */) = valueToBeExtracted valueToBeExtracted match { case extractor(extractedValue1, _) => ???} val (tuple1, tuple2, tuple3) = tupleWith3Elements object Foo { def unapply(foo: Foo): Option[String] = Some(foo.x); }

MySQL 5.7.8+ supports native JSON type. While you have different ways to create json objects, you can access and read members in different ways, too. Main function is JSON_EXTRACT, hence -> and ->> operators are more friendly. JSON_EXTRACT(json_doc,path[,...]) JSON_EXTRACT(json_doc,...