[Koha-bugs] [Bug 21906] WHERE clause doesn't like % in CONCAT
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Dec 7 20:25:46 CET 2018
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21906
Jonathan Druart <jonathan.druart at bugs.koha-community.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |jonathan.druart at bugs.koha-c
| |ommunity.org
--- Comment #3 from Jonathan Druart <jonathan.druart at bugs.koha-community.org> ---
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
--
You are receiving this mail because:
You are the assignee for the bug.
You are watching all bug changes.
More information about the Koha-bugs
mailing list