I have an images database, the default sort is the "name" column, and the "description" column content is the exact same in all files in the table. what I need is to replace certain text in the "description" with numbers respectively.
Example of the "description" entry to all items:
"Photo number # more text text"
The query should replace the
"#" symbol with sequential numbers, ordered by 'name' column. Where the first row should be
Photo number 1, and second
Photo number 2.. etc.
I tried some queries with row_number (in phpmyadmin), but I am not sure if it is the right way to do that or what.. as they didn't work.
Server version: 5.7.24-0ubuntu0.16.04.1 - (Ubuntu)