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

https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21906 --- Comment #4 from Christopher Brannon <cbrannon@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.