https://bugs.documentfoundation.org/show_bug.cgi?id=143656
m.a.riosv <miguelange...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |miguelangelrv@libreoffice.o
| |rg
Status|UNCONFIRMED |RESOLVED
Resolution|--- |NOTABUG
--- Comment #1 from m.a.riosv <miguelange...@libreoffice.org> ---
See the help
https://help.libreoffice.org/latest/en-US/text/sdatabase/02010100.html?&DbPAR=BASE&System=WIN
search for
Like Escape Sequence: {escape 'escape-character'}
Example: select * from Item where ItemName like 'The *%' {escape '*'}
The example will give you all of the entries where the item name begins with
'The *'. This means that you can also search for characters that would
otherwise be interpreted as placeholders, such as *, ?, _, % or the period.
So in LO you need to escape *, with in direct-sql not.
I think it's not a bug, it is how it works. Maybe there was a reason to
implement such think in base.
--
You are receiving this mail because:
You are the assignee for the bug.
