At 18:07 +0100 5/18/04, James Tusini wrote:
I was wondering if there's a way to set a field to be a pattern of another
field in the same table, ie:
number file
1 xyz_1.jpg
2 xyz_2.jpg
3 xyz_3.jpg
.
.
n xyz_n.jpg
I'm achieving this through php but was curious to know if you could do it
directly in MySQL as it would probably be much more efficient.
You have to do it yourself.
However, if there is a fixed relationship between the two columns, there
is probably little to gain by storing both of them. Just generate the
filename from the number when you issue a retrieval statement.
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
