Mysql Regular Expression Query

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'