Welcome to WebmasterWorld Guest from 54.224.214.251

Forum Moderators: open

Message Too Old, No Replies

Perform advanced searches in SELECT statement

     
4:23 pm on Sep 8, 2009 (gmt 0)

Junior Member

10+ Year Member

joined:Sept 26, 2005
posts:92
votes: 0


Hello all
I wanted to ask if there is a way of inserting some mathematics in an SQL select statement.
What I am interested in is to select all rows from a table where 56<ID<67 for example.

Thank you

8:32 pm on Sept 8, 2009 (gmt 0)

Senior Member from US 

WebmasterWorld Senior Member 5+ Year Member

joined:Nov 11, 2007
posts:769
votes: 1


SELECT *
FROM mytable
WHERE ID > 56 AND ID < 67

You can put mathmatics in lots of parts of a SQL SELECT statement...