There is a table, select * from table :
ID | name | photos | ------------------------------------------------------------------------------- 1 | name 1 | {http://.../photos_1, http://.../photos_2, http://.../photos_3} 2 | name 2 | {http://.../photos_1, http://.../photos_2, http://.../photos_3} I need to display only the first url from the photos column, but not the rest.
To make it so:
ID | name | photos | ---------------------------------- 1 | name 1 | http://.../photos_1 2 | name 2 | http://.../photos_1 How to create such a request?
