Less than or equal to.

[korrupt_23]

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.

[mtoynbee]

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

[korrupt_23]

Thanks man!