![]() ![]() WHERE name GLOB '*' Code language: SQL (Structured Query Language) ( sql ) The following statement finds the tracks whose names end with a number. Or to find the tracks whose name does not contain any number, you place the character ^ at the beginning of the list: SELECT WHERE name GLOB '**' Code language: SQL (Structured Query Language) ( sql ) To find the tracks whose names contain numbers, you can use the list wildcard as follows: SELECT WHERE name GLOB '?ere*' Code language: SQL (Structured Query Language) ( sql ) The following query finds the tracks whose names start with any single character (?), followed by the string ere and then any number of character (*). WHERE name GLOB '*Man' Code language: SQL (Structured Query Language) ( sql ) The pattern *Man matches any string that ends with Man. The following statement gets the tracks whose names end with Man. WHERE name GLOB 'Man*' Code language: SQL (Structured Query Language) ( sql ) The pattern Man* matches any string that starts with Man. The following statement finds tracks whose names start with the string Man. For example, the pattern matches any single character except a numeric character. The pattern matches any single alphanumeric character, both lowercase, and uppercase.īesides, you can use the character ^ at the beginning of the list to match any character except for any character in the list. The list wildcard also allows a range of characters e.g., matches any single lowercase character from a to z. For example match any single x, y, or z character. On top of these wildcards, you can use the list wildcard to match one character from a list of characters. The question mark (?) wildcard matches exactly one character.The asterisk (*) wildcard matches any number of characters.The following shows the wildcards used with the GLOB operator: In addition, the GLOB patterns do not have escape characters. Unlike the LIKE operator, the GLOB operator is case sensitive and uses the UNIX wildcards. The GLOB operator determines whether a string matches a specific pattern. The GLOB operator is similar to the LIKE operator. Summary: in this tutorial, you will learn how to use the SQLite GLOB operator to determine whether a string matches a specific pattern. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |