Jump to content


Photo

Less than or equal to.


  • Please log in to reply
2 replies to this topic

#1 korrupt_23

korrupt_23
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 18 November 2003 - 02:22 AM

Well, I\'m attempting to use a query to select a column and check if it\'s = to a number.

I have a vague idear, but it doesn\'t seem to wanna work...

Thanks in advanced everyone, all this small question really help me.
KoRRupt

#2 mtoynbee

mtoynbee
  • Members
  • PipPipPip
  • Advanced Member
  • 111 posts
  • LocationHythe, SE England

Posted 18 November 2003 - 12:43 PM

SELECT * FROM table WHERE number = 1

replace \"table\" with the name of your table
and \"number\" to name of the column you wish to check

Other examples:

Less than:

SELECT * FROM table WHERE number < 1

Greater Than:

SELECT * FROM table WHERE number > 1

Between

SELECT * FROM table WHERE number BETWEEN 1 AND 3

#3 korrupt_23

korrupt_23
  • Members
  • PipPip
  • Member
  • 13 posts

Posted 19 November 2003 - 03:39 AM

Thanks man! 8)
KoRRupt




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users