大约有 44,000 项符合查询结果(耗时:0.0525秒) [XML]
Using “like” wildcard in prepared statement
...lue itself, not in the prepared statement SQL string.
So, this should do for a prefix-match:
notes = notes
.replace("!", "!!")
.replace("%", "!%")
.replace("_", "!_")
.replace("[", "