The same =
search for equivalence character by character, has to be exactly equal.
Already the LIKE
looks for "something like", ie content that has the text searched in a part of where (column(s)) you are looking for. In general the symbol is used %
to indicate where there may be wildcard characters, where there may be anything else.
The use of '1kvsg4oracxq%' still allows the use of an index, but anywhere else it can disable the indexed consumption and have poor performance, or even tragic (depends, has to measure, is not always bad). In such cases use a inverted index for full text search may be more appropriate.
The _
is also used for only one wildcard character. Some syntaxes allow other ways to express what you can use.
Without the %
the result is to be the same. But there is an exception, which is about the spaces at the end. The =
usually ignores them. If not using %
in the LIKE
, they will not be ignored.
Rela: https://answall.com/q/191573/101
– Maniero