SQL: change duplicates. how to do?

Question

MySQL

Is it possible to implement the following without resorting to php. there is a url table, the keyword field contains the product alias, some may be the same, how to make a request to change the alias for duplicates, for example, add a random number

Answer 1

SET @r=0;
select id,tname,CONCAT (taliase , addid) as aliase from 
(
   select * from (
            SELECT  id,tname,taliase,@r:[email protected]+1 as addid
            FROM FF as f1
            GROUP BY f1.tname,f1.taliase
            UNION 
            SELECT  id,tname,taliase,"" as addid FROM FF as f2
            GROUP BY f2.taliase
            ORDER BY taliase DESC
            ) as t1
   order by t1.id,t1.addid
   
) as t2
group by t2.id

the sign was like this:

CREATE TABLE FF
  (`id` int, `tname` varchar(20), `taliase` varchar(20))
;
  
INSERT INTO FF
  (`id`, `tname`, `taliase`)
VALUES
  (1, 'baranka', 'hleb'),
  (2, 'bulka', 'hleb'),
  (3, 'pirozhok', 'hleb'),
    (4, 'konfeta','sladkoe'),
    (5, 'karamel','sladkoe')
;

Answer 2

update table as t1
inner join 
(
  select 
  keyword,
  count(*) as cnt
  from table
  group by keyword
) t2 on t2.keyword = t1.keyword
set t1.keyword = concat(t1.keyword, floor(rand() * 10000000)) 
where t2.cnt > 1