Octavian
Reputation: 4579
Count number of LineStrings in a MultiLineString MySQL
Is there a sql way to count the number of linestrings in a multilinestring field in MySQL? ST_Numpoints(multilinestring_field) returns null.
Upvotes: 0
Views: 168
Answers (1)
Octavian
Reputation: 4579
I think the answer is using ST_NumGeometries - https://dev.mysql.com/doc/refman/8.0/en/gis-geometrycollection-property-functions.html#function_st-numgeometries
Upvotes: 1
Related Questions
- How to count the number of characters on each line with group by
- Count occurrences in string via MySQL
- Count total number of multiple line items in MySQL
- MySQL Count number of substring occurrences in column
- count multiple occurence substrings in MySql
- SQL multiple line count
- Mysql: How many times a value appear in each line
- Count number of lines depending of criteria (similar to group by)
- mysql count geo query
- mySQL count occurances of a string