Using "LIKE" operator in Rest API with "%" symbol at the end

I’m using “%” on my “LIKE” filters but seems it only works if it placed in the end. for example:

{{host}}api/resource/Fees?fields=[“*”]&filters=[[“name”,“LIKE”,“EDU-FEE-2023%”]]

it will return some results…

But this one:

{{host}}api/resource/Fees?fields=[“*”]&filters=[[“name”,“LIKE”,“%2023-00002”]]

it will return empty result

Why it happens? Am I using it wrong?

In SQL and Frappe queries, using % at the beginning of the search pattern is not always supported, and it might not work as expected. The % wildcard is typically used for matching at the end or both ends of the pattern.

If you want to perform a substring match for records that contain “2023-00002” anywhere in the name, you can use % at both ends

you mean something like this:

[[“name”,“LIKE”,“%2023-000%”]]

??
because it also not working. nothing return