modified content has been compiled. Also check the document for countless steps to verify that the operation is correct. Toss for a long time no fruit, but gave up on board the idea of compiling, updating. On the PC side recompile tx2 kernel, the new kernel and DTB file copy to jetpack installation directory to store the kernel image and DtB file location, brush machine, restart Board, add to DTSi in the device node finally appeared. The command for
Tags: regular expression mysqlThe Products table is as follows:1. Basic character MatchingUsing regular expressions and like, the regular expression is searched throughout the column, as long as the prod_name contains the characters that are searched, and if you do not use wildcards, then the prod_name is required to match the search characters exactly: that is, the following example needs to be used Like ' JetPack 1000 ' can be adapted to a search.2
: When is the operator not an operator? The answer is when it acts as a predicate (predi-cate). Technically, like is a predicate rather than an operator. Although the end result is the same, you should be aware of the term in order to avoid encountering this term in a SQL document. 17. Regular Expressions: REGEXP: It tells the mysql:regexp what to do with the regular expression (a regular expression that matches the text body 1000).
The regular expression differs from the
match anything, there is one exception, that is, NULL. Even WHERE prod_name like '% ' does not match the line with the value NULL as the product nameregular expression matches in MySQL are case-insensitive and are case- sensitive, using the binary keyword, such as where prod_name REGEXP binary ' JetPack. 000 'Full-Text Search:Performs a full-text search using two function match () and against () after specifying fulltextWant to find out all the notes
begins with Jet will be retrieved. % tells MySQL to accept any character after jet, regardless of how many characters it has.Case sensitivity depending on how MySQL is configured, the search can be case-sensitive. If case sensitivity, ' jet% ' and jetpack 1000 will not match.Wildcards can be used anywhere in search mode, and multiple wildcard characters can be used. The following example uses two wildcard characters, which are located at both ends of
. Trailing spaces may interfere with wildcard matching. Like matches the entire column, and if the matched text appears in the column values, like will not find itSELECT Prod_id,prod_name,prod_price from Products WHERE prod_name like 'jet% '; (Search for any word that begins with Jet)16, regular expression, is used to match the text of the special string (character set). . (dot) is a regular expression language that matches any one character, and the following 1000 and 2000 match. RegExp matche
^ and $ locator (anchor), described later in this chapter.Matching case-insensitive regular expression matching in MySQL is case insensitive (that is, uppercase and lowercase matches). For case sensitivity, you can use the binary keyword, such as where Prod_name REGEXP BINARY ' JetPack. 000 '.9.2.2 for or matchingTo search for one of two strings (either for this string, or for another string), use | as follows:The regular expression 1000|2000 is used
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.