Retrieving the coordinates of the MySQL point type

by

Let’s say you store GeomFromText('POINT(32 -122)') as a column called MY_POINT in a table called MY_TABLE.

Getting the X coordinate (will return 32 in this example):

SELECT ST_X(MY_POINT) as longitude FROM MY_TABLE;

Getting the Y coordinate (will return -122 in this example):

SELECT ST_Y(MY_POINT) as latitude FROM MY_TABLE;

Important: Prior to version 5.6, use X() and Y() instead of ST_X() and ST_Y().

More Related Contents:

  1. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  2. multiple query same table but in different columns mysql
  3. How can I make SQL case sensitive string comparison on MySQL?
  4. Import data in MySQL from a CSV file using LOAD DATA INFILE
  5. Library not loaded: libmysqlclient.16.dylib error when trying to run ‘rails server’ on OS X 10.6 with mysql2 gem
  6. Count the occurrences of DISTINCT values
  7. Column count doesn’t match value count at row 1
  8. MySQL > Table doesn’t exist. But it does (or it should)
  9. INSERT INTO … SELECT FROM … ON DUPLICATE KEY UPDATE
  10. How do I modify a MySQL column to allow NULL?
  11. Connect to mysql in a docker container from the host
  12. MySQL update CASE WHEN/THEN/ELSE [duplicate]
  13. mysql trigger stored trigger is already used by statement which invoked stored trigger
  14. Error Dropping Database (Can’t rmdir ‘.test\’, errno: 17)
  15. mysql update query with sub query
  16. How can I implement single table inheritance using Laravel’s Eloquent?
  17. Converting SELECT DISTINCT ON queries from Postgresql to MySQL
  18. What is the difference between the backtick and the square bracket in SQL statements?
  19. Integrity constraint violation: 1452 Cannot add or update a child row:
  20. How to change the mysql root password
  21. How can I set autoincrement format to 0001 in MySQL?
  22. What does SQL Select symbol || mean?
  23. Why MYSQL IN keyword not considering NULL values
  24. What’s the recommended way to connect to MySQL from Go? [closed]
  25. MySQL. Can’t create table errno 150
  26. What does it mean by select 1 from table?
  27. apache mysql – “packets out of order” on 3306
  28. ORDER BY alphabet first then follow by number
  29. mysql create table dynamically
  30. Errno 121, duplicate key on write or update?

Leave a Comment