[BL]% '

This way of writing,

It seems that only

Structured query language

Computer network server

Support,

Not supported by other databases.

regular expression

This is a regular expression match.

where

city

regular expression

'^[BL]'

Do it.

Is satisfaction.

believe

B

or

L

At the beginning,

Get it back.

because

%

It is used for

like

Yes

Not for

Of a regular expression.

regular expression

and

like

Different matching

Like requires all data to match, while REGEXP only needs partial matching.

That is to say, with Like, all the contents of this field must meet the conditions, while REGEXP only needs any fragment to meet them.