[Koha-bugs] [Bug 21906] WHERE clause doesn't like % in CONCAT

[bugzilla-daemon at bugs.koha-community.org]

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21906

--- Comment #4 from Christopher Brannon <cbrannon at cdalibrary.org> ---
(In reply to Jonathan Druart from comment #3)
> I have tried:
> - Create a new report from SQL
> 
> SELECT itemnumber, itemcallnumber FROM items WHERE itemcallnumber LIKE
> CONCAT(<<Start of call number>>,'%')
> 
> - Execute
> - Enter "a"
> => Return 2 results
> - Export (csv, tab, ods)
> => Return 2 results
> 
> on master

And what happens if you don't fill in the field?

-- 
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.