网络营销电子商务研究中心  
How to buy the best prescription safety glasses in Canada? Let's study!
Go Back   网络营销电子商务研究中心 > 服务器与数据库 > MySQL
Reload this Page Mysql语句中查询字段中大于某个数且小于某个数之间的条件怎么设定
User Name
Password
　
FAQ Members List Calendar Cheap Glasses Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1   IP: 49.87.41.166
Old 2015-03-05, 06:05 AM
Kairi Kairi is offline
初级会员
  
Join Date: 2007-10-13
Posts: 1
Kairi 现在声名狼藉
Default Mysql语句中查询字段中大于某个数且小于某个数之间的条件怎么设定
如我要查大于10000的数据就是SELECT * FORM tables WHERE price > 10000;小于10000就是SELECT * FORM tables WHERE price > 10000;现在我要查 大于1000小于2000的，就是 1000<price<2000怎么查？
Reply With Quote
  #2   IP: 49.87.41.166
Old 2015-03-05, 06:06 AM
Kankakee Kankakee is offline
初级会员
  
Join Date: 2012-02-26
Posts: 1
Kankakee 现在声名狼藉
Default
SELECT * FORM tables WHERE price > 10000 and price < 20000
Reply With Quote
Reply

« Previous Thread | Next Thread »

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes
Hybrid Mode Hybrid Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Prescription-glasses.com offers prescription glasses online at discount prices.
All times are GMT +8. The time now is 03:10 AM.

配镜中心 - 电子商务网络营销研究中心 - Archive - Top

Powered by vBulletin Version 3.8.7
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.