Answers for "get one record in duplicate id in php mysql"

PHP
0

finding duplicate rows mysql

SELECT varchar_col
FROM table
GROUP BY varchar_col
HAVING COUNT(*) > 1;
Posted by: Guest on October-20-2021
0

get duplicate value from array php

$arr = array(1, 4, 6, 1, 8, 9, 4, 6);

$unique = array_unique($arr);

$duplicates = array_diff_assoc($arr, $unique);

print_r($duplicates);
Array ( [3] => 1 [6] => 4 [7] => 6 )
Posted by: Guest on October-08-2020

Code answers related to "get one record in duplicate id in php mysql"

Browse Popular Code Answers by Language