Mysql field value value range of the search-CodePudding

Ask a question: I want to condition search multiple fields, the field value for 4 to 10, the search criteria is 5, included in the 4 to 10, through what way can search out? Thank!!!!!

CodePudding user response:

Selete *
From the table
Where cola=5 or colb=5 or colc=5

CodePudding user response:

Select the columns from a table column=5

CodePudding user response:

What you need, for example, what you said above is not very clear

CodePudding user response:

Problem description is not clear,

CodePudding user response:

Reference

suggest you list your table structure, and provide the test data, and based on these test data that corresponds to the correct result,
Refer to the way the post questions http://bbs.csdn.net/topics/320211382

1. You create table XXX.. Statement
2. You insert into XXX... Statement
3. The result is what kind, and give a simple algorithm description)
4. Do you use the database name and version of (often asked in MS SQL server edition MySQL)

So people who want to help you to build the same environment with you directly, and in providing the test before, avoid the error in the text understanding,

CodePudding user response:

reference

junction post rate: 0%

When you the solutions of the problems please post.
http://topic.csdn.net/u/20090501/15/7548d251-aec2-4975-a9bf-ca09a5551ba5.html
http://topic.csdn.net/u/20100428/09/BC9E0908-F250-42A6-8765-B50A82FE186A.html
http://topic.csdn.net/u/20100626/09/f35a4763-4b59-49c3-8061-d48fdbc29561.html

8, how to give points and knot stick?
http://bbs.csdn.net/help#post_dispose