User defined function in a mysql query

From: Date: Wed, 10 Dec 2003 15:43:15 +0000
Subject: User defined function in a mysql query
References: 1 2  Groups: php.db 
Request: Send a blank email to php-db+get-31964@lists.php.net to get a copy of this message
Hi, 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? Thanks Antonio Bernabei

« previous php.db (#31964) next »