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

This article introduces the relevant knowledge of "what is the role of in in mysql". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

In in mysql is often used in where expressions to query data within a range. The following will be edited to show you the use of in in mysql, which can be referred to by friends in need.

In is often used in where expressions to query data within a range.

Usage: select * from where field in (value1,value2,value3, …)

Example: query all data with id 2 and 4 in the book table:

There is a book data sheet, which contains the following contents:

The query statement and the query results are shown in the following figure:

PS: not in has the opposite effect as in. The usage and examples are as follows:

Usage: select * from where field not in (value1,value2,value3, …) .

Not in example:

This is the end of the content of "what is the role of in in mysql". Thank you for your reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

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.