The statement can be used with negation: NOT LIKE. Select name, family from personal where name like 'A%В_' The search for the characters " % " and " _ " is carried out using the constructions " \% " and " \ _ ". " % " - Corresponds to any number of characters and their absence, too. Together with the operator LIKE you can use special characters: String comparisons are case insensitive unless the BINARY keyword is used, meaning that the string should be treated as a binary sequence. The operator is often used in the WHERE clause and returns 1 or 0. The LIKE operator is designed to compare strings using simplest regular expressions. With their help, you can solve such tasks with one line: “check whether the line contains numbers”, “find all email addresses in the text”, “replace several consecutive question marks with one”. Regular expressions are special patterns for searching for substrings in text. ЙMySQL DBMS has various tools for searching, among which is the LIKE operator, which performs the simplest search operations, the RLIKE operator, which provides the ability to search by regular expressions.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |