@@ -, +, @@ COALESCE() --- C4/Items.pm | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) --- a/C4/Items.pm +++ a/C4/Items.pm @@ -1375,7 +1375,7 @@ sub _SearchItems_build_where_fragment { } if ( defined $ifnull ) { - $column = "IFNULL($column, ?)"; + $column = "COALESCE($column, ?)"; } if (ref $query eq 'ARRAY') { --