Community Learn Tools Library Leisure
search
English
Home > Backend Development > PHP Tutorial > body text

SQL 查询问题

WBOY
Release： 2016-06-23 13:36:21
Original
909 people have browsed it

比如，数据表中有r4字段，内容是 
a0010b
a0020b
a0030b
a0040b

现在要按范围查询，a0020b到a0040b 之间的内容

表单：请填写最小单号_____请填写最大单号_____

查询语句怎么写？
谢谢


回复讨论(解决方案)

where r4>=a0020b and r4

有没有人会？

Related labels：
SQL 查询问题
source：php.cn
Previous article：PHP断点续传的原理与实现 Next article：高手来,关于php中socket的问题!
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Calculate the sum of fields in another table using MySQL SQL query I have a schema like this: User table with attributes "user_id" and "userna...
From 2024-04-06 19:39:29
0
1
441
Scatterplot points do not maintain values ​​when zooming in d3.js This is my first time using d3.js, so please bear with me. I implemented it as pure JavaSc...
From 2024-04-06 18:16:26
0
1
403
Record query under partial value conditions - SQL skill sharing I have a table called zipcode which has a column called code. The Code column contains the...
From 2024-04-06 16:01:26
0
1
395
Node.js: Unable to store SQL query results in an array I'm trying to push the results of a SQL query to an array. However, it doesn't seem to wor...
From 2024-04-06 14:14:46
0
1
373
**Error type: Unable to iterate 'NoneType' object** I want to use ssh tunnel to access Mysql database. Unfortunately, the architecture of this...
From 2024-04-06 10:26:38
0
1
378
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template