RE: SQL and evaluating expressions

2003-10-10 Thread Stephen Rich
Okay, after reading the MySQL manual I figured out how to get what I want. Can anyone advise me where to send such newbie questions in the future so that I would get a response? I realize my question was a SQL database question and not a MySQL-specific database question, but I figured the audienc

SQL and evaluating expressions

2003-10-10 Thread Stephen Rich
Can SQL statements evaluate expressions? I want to store thousands of equations, and return a subset when I plug in a value. For instance, if I stored the following two equations: x = y + 5; x = 100 / y; I might want to query for all records whose x is less than 10 when y is equal to 3. I'd ex

finding equations intersections

2003-10-10 Thread Stephen Rich
I have a simulation of moving objects that interact with each other. If I store the object positions as coordinates, I think I will need at least one database call for every object to determine intersections. [for N objects there are N database calls] I'm wondering if I could do the same thing st