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 shown below:
- A-Z → Match alphabetic characters
- 0-9 → Macth digits
- !@#$%&()_+-={}:";'<>?,./~ → Match corresponded symbol
- \| → Match "|" and because "|" is reserved character, escape character "\" is required.
- \\ → Match "\" and because "\" is reserved character, escape character "\" is required.
|
Input "[A-Z0-9][A-Z0-9]2*" which means first and second position is alphanumeric characters and third position is "2", there are 4 records returned. |
|
Input "*[-/]*" which means the result should contain "-" or "/", there are 5 records returned. |
Logical Operator
Use "|" to execute logical operator "OR", that means input multiple conditions is acceptable.
|
Input "A0*|W9*", 3 records returned. |
Comments
Post a Comment