Moderator: General Moderators
mikosiko wrote:one easy alternative is using GROUP_CONCAT() comparing the result with whatever string you like.
VladSun wrote:Common solution to find non successive numeric "holes" (though it would be just the first element) in series:SELECT
`table`.`field` + 1 AS `missing_field`
`table` AS `missing_field_table` ON
`table`.`fielld` + 1 = `missing_field_table`
`missing_field_table`.`field` IS NULL
PostgreSql has a set returning function called generate_series which is very useful in such cases - you can try implement it in MySQL and use it in a similar way as the one show above.
wvoyance wrote:......I want to find out which PID is incomplete, i.e. do not have three language tuples 1,2,3.