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
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
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