How to search by like query in sales order grid?

by |Published March 1, 2022

I’m using Order’s increment ID in the search by keyword field to get the search results. However, it only works with 00000XXXX and not by XXXX.
Search by keyword is using Fulltext searching but how to get the results with the like query?

Please share the solution.