Syntax\n------\n\nST_GeoHash(longitude, latitude, max_length)\nST_GeoHash(point, max_length)\n\nDescription\n-----------\n\nReturns the geohash corresponding to the input values, or NULL if any argument is NULL. Geohashes encode latitude and longitude coordinates into a text string made up only of numeric and lowercase latin letter characters.\n\nThe longitude parameter is a numeric value in the interval \\[180, -180]. latitude is a numeric value in the interval \\[90, -90].\n\nIn the case of point, the x coordinate is treated as the longitude and the y coordinate is treated as the latitude. The same constraints apply.\n\nThe max_length parameter is the upper limit on the resulting string size and cannot exceed 100.\n\nThe ST_LatFromGeoHash function decodes a given geohash and returns the latitude.\n\nExamples\n--------\n\nSELECT ST_GeoHash(ST_GeomFromText('POINT(1 1)'),15), ST_GeoHash(0,30,15);\n+----------------------------------------------+---------------------+\n| ST_GeoHash(ST_GeomFromText('POINT(1 1)'),15) | ST_GeoHash(0,30,15) |\n+----------------------------------------------+---------------------+\n| s00twy01mtw037m                              | sj248j248j248j2     |\n+----------------------------------------------+---------------------+\n\nURL: https://mariadb.com/docs/server/reference/sql-statements/geometry-constructors/miscellaneous-gis-functions/st_geohash