File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes Possible reuse of math in select used in where Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Possible reuse of math in select used in where" Watch "Possible reuse of math in select used in where" New topic
Author

Possible reuse of math in select used in where

Dom Lassy
Ranch Hand

Joined: May 05, 2006
Posts: 181
I have the current MYSQL query:


Without using a function or stored procedure, how can I accomplish something like this (I can't get it to work)?
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: Possible reuse of math in select used in where
 
Similar Threads
Math Puzzle - Where Are You?
limiting the size of a resultset - Breaking up large resultset into chunks
SQL question: returning the posts between rank y and z
Surprisingly Complex Images Generated From Very Simple Code
"Store Locator" sql results