What are wild cards used in database for Pattern Matching ?

Posted by

To view Verified answers click on the button below.

SQL Like operator is user for pattern matching. SQL ‘Like’ command takes more time to
process. So before using like operator, consider suggestions given below on when and
where to use wild card search.
1) Don’t overuse wild cards. If another search operator will do, use it instead.
2) When you do use wild cards, try not to use them at the beginning of the search pattern,
unless absolutely necessary. Search patterns that begin with wild cards are the slowest to
process.
3) Pay careful attention to the placement of the wild card symbols. If they are misplaced,
you might not return the data you intended