Regular Expression matching query: wildcard. english periods, matching any single character; * matching 0 or more characters before it; x * Indicates matching any number of x characters [...] match any [abc] character in brackets. Match a, B, or c [a-z]. match any letter. [0-9] match any number. [0-9] * ^ represents a character or string
Regular Expression matching query: wildcard. english periods, matching any single character; * matching 0 or more characters before it; x * Indicates matching any number of x characters [...] match any [abc] character in brackets. Match a, B, or c [a-z]. match any letter. [0-9] match any number. [0-9] * ^ represents a character or string
Regular Expression matching query:
Wildcard
. English periods, matching any single character;
* Matches 0 or more characters before it;
X * Indicates matching any number of x characters.
[...] Matching any character in brackets
[Abc] matches characters a, B, or c
[A-z] matches any letter.
[0-9] matching any number
[0-9] *
^ Indicates starting with a character or string ^ a indicates starting with the letter
$ Indicates ending with a character or string x $ indicates ending with the letter s
SELECT prod_name FROM products WHERE prod_name REGEXP '^ NB 'order BY prod_name;
To be case sensitive, you can use the BINARY keyword. For example, WHERE prod_name regexp binary 'jetpack. 000'