Regular Expressions 101

(?i)applies the following effective flags to the remainder of the pattern: gmi

i modifier: insensitive. Matches without distinguishing uppercase and lowercase letters

Group 1(\s|.)*

*repeats the group contents below any number of times:

1st Alternative\s

\sany whitespace character

2nd Alternative.

.any character (except for line terminators)

\ban ASCII word boundary

LONG BLOBthe literal text LONG BLOB (case insensitive)

\ban ASCII word boundary

Global pattern flags

g modifier: global. Finds all matches instead of stopping after the first

m modifier: multiline. Causes ^ and $ to match the start and end of each line, not only the start and end of the string

Detailed match information will be displayed here automatically.

Search reference

Regular Expression

(?i)(\s|.)*\bLONG BLOB\b

New

add 
CHARACTER SET
COLLATE long blob