I have a column in my MySQL database table that contains location information (GeoJSON).
I want to import this data and see the points on my QGIS project map but it doesn't seem to work. What I was trying to do:
Layer -> Add Layer -> Add Vector Layer -> Database -> insert the server configuration -> Add -> import the relevant table.
I missed the query. I used the query builder and it seems to find around 200 relevant rows, but it shows only 1 point on the map. In addition, the point is not in the right spot...