Ich vermute mal du suchst SUBSTRING: http://dev.mysql.com/doc/refman/4.1/...tion_substring
bsp:
SELECT * FROM x LEFT_JOIN y ON (x.foo = SUBSTRING(y.bar, 4))
jak
____________________________________
Join the DNRC | Godwin\'s Law (thx@stona)
Documentation is like sex: If it\'s good, it\'s very, very good. If it\'s bad, it\'s better than nothing.
\"In theory, theory and practice are the same. In practice, they are not\" (Lawrence Berra)
|