I've never seen/used that syntax in global search, you can use

%

as a wildcard in global search, but not with SQL syntax afaik