check sentence
SELECT
In the statement
WHERE
Matching expressions in clauses match the pattern string, at the same time, the matching expression symbol is
=
,
<>
,
>
,
<
,
in
,
NOT IN
,
Exists
,
NOT EXISTS
Will ignore the pattern string of the first tail space. E.g:
Select * from table1 where a = 'abc', the space in the tail of the mode string 'ABC' will be ignored when matching. However, if you use the LIKE expression symbol, space will not be ignored.
