Jump to content

Archived

This topic is now archived and is closed to further replies.

korrupt_23

Less than or equal to.

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.