Shulou(Shulou.com)05/31 Report--

Most people do not understand the knowledge points of this article "how to use the mysql module", so the editor summarizes the following content, detailed content, clear steps, and has a certain reference value. I hope you can get something after reading this article. Let's take a look at this "how to use the mysql module" article.

Description

1. As a conditional query, instr is actually the returned string index position.

2. If as a condition, the corresponding value of the column name matches and returns one, the whole table scans all the data to get all the matching data.

The INSTR function takes two parameters:

Str is the string to search for.

Substr is the substring to search for.

Example

SELECT productNameFROM productsWHERE INSTR (productname,'Car') > 0; the above is about the content of this article on "how to use the mysql module". I believe you all have some understanding. I hope the content shared by the editor will be helpful to you. If you want to know more about the relevant knowledge, please follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.