Strategy for partial text search

Users Dgraph
4

This was probably one of the biggest challenges in development for us. How do we do “global searches” that we are use to doing with MySQL like operator and wild cards across dynamically concatenated fields.

SELECT
  *
FROM
  user
  LEFT JOIN address ON ...
WHERE
  CONCAT_WS(user.username, user.first_name, user.last_name, address.city, address.state) LIKE `%jo%`

It is IMPOSSIBLE to do this in Dgraph.