In "Jus Ask Innoavtor", we could learn some tips for querying data in simple search mode. But I would use those tips with examples to make it easier to understand. Suppose there are 5 records in my database. Exact String Matching Input words or terms without any special symbol will execute exact string matching. Input "A0119B/11101", 1 record returned. Input "A0119B", nothing returned. Input "11101", nothing returned. Approximate String Matching Use "*" or "%" as wildcard character to execute approximate string matching. Input "A0*", 2 records returned. Input "*1", 3 records returned. Input "*ED*", 2 records returned. Input "A*1*1", 1 record returned. Regular Expression Matching Use square brackets with simple regular expression to execute a query is acceptable, all allowed terms (which are tested by myself and refer to this article ) are sh...
Comments
Post a Comment