SQLite Fuzzy Lookup (like)

Select Userid,username,name,sex,birthday,height,weight,role from Xqhit_users
where UserName like "%yym%" limit offset 0

Name like "%values%" or name like '%values% ' can be.

SELECT * from db.table limit offset 0; Limit fetch 50 Offset skip 0 general paging common

SQL Fuzzy query statementFor SQL Fuzzy queries, using the like comparison word, plus the wildcard characters in SQL, refer to the following: 1. Like ' mc% ' will search for all strings starting with the letter Mc (such as McBadden).　　2. Like '%inger ' will search for all strings ending with the letter inger (such as Ringer, Stringer).　　3. Like '%en% ' will search all strings containing the letter en in any location (e.g. Bennet, Green, McBadden).　　4. Like ' _heryl ' will search for all six-letter names (such as Cheryl, Sheryl) ending with the letter heryl.　　5. Like ' [Ck]ars[eo]n ' will search for the following strings: Carsen, Karsen, Carson, and Karson (such as Carson).　　6. Like ' [M-z]inger ' will search for all names (such as Ringer) ending with the string inger, starting with any single letter from M to Z.　　7, like ' m[^c]% ' will search starts with the letter M, and the second letter is not all names of C (such as Macfeather). The following sentence query string, according to the variable Zipcode_key in the Postal Code table zipcode query the corresponding data, this sentence is the judgment variable Zipcode_key is not a number when the query statement, with% to match any length of string, from the table address, city, All data items that contain keywords are queried in the save three columns and sorted by province, city, and address.　　This is a simple example, so you can write more complex query statements as long as you understand the method. sql = "SELECT * from ZipCode where (address like '%" & zipcode_key & "% ') or (city like '%" & Zipcode_key & "% ') or (province like '%" & zipcode_key & "% ') Order by province,city,address

SQLite Fuzzy Lookup (like)