List:General Discussion« Previous MessageNext Message »
From:Rob Date:October 17 2003 8:10am
Subject:RE: Help in querying
View as plain text  
SELECT * 
FROM <tablename>
WHERE value > 915

-----Original Message-----
From: delz [mailto:delz@stripped] 
Sent: Friday, October 17, 2003 9:46 AM
To: mysql@stripped
Subject: Help in querying


Hi All,

I'm using mysql as my database. I have a table which has the following
colums:

idx
productname
value

My question is how do i display and select all the data that has a value
of more than 915.

Hope you can help.

Regards,

Delz



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1


Thread
natural sortingMichael Winston16 Oct
  • Re: natural sortingDan Nelson16 Oct
    • Re: natural sortingMichael Winston17 Oct
      • Re: natural sortingRoger Baklund17 Oct
        • Help in queryingdelz17 Oct
          • RE: Help in queryingRob17 Oct
  • Re: natural sortingTobias Asplund16 Oct