From: "antonio bernabei" <[EMAIL PROTECTED]>

> I need to make a join between two tables. And I can use the mysql_query
> function: this is ok.
> The problem arises because I need to apply a user defined function to a
> field of one of the two tables and the rule for the join is WHERE
> table1.filed1=function(table2.field2).
> But I receive a lot of errors: it seems like is not allowed to put such a
> function in the text of the query. Or there is a possibility?

You should be able to do this.. you're just doing a comparison. Although
it'll negate any indexes you have and make for a very slow join. We are
talking about a MySQL function, right... and not a PHP one??

---John Holmes...

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to