PHP MySQL Query insert Function

Question

Is there any possibilty to add a function-call in a SQL-Query?

At the moment i'm doing this:

§sql = "SELECT * FROM TABLE";

But I want, that I'm using a field from my table and call with this a function, which return me true or false.

Maybe a example could explain it better:

"$sql = SELECT * FROM TABLE WHERE functionCall(TABLE.FIELD)=true";

Then I just get all entrys from TABLE, where my function returns true.

Is there any possibility to do that?

Read MySQL manuals for built-in functions. I think you can do your task with them — u_mulder
– u_mulder, Commented May 4, 2014 at 17:49
in addition: you can write stored functions, those will work too. But you can't refer to a php function ... — VMai
– VMai, Commented May 4, 2014 at 17:52

echo_Me · Accepted Answer · 2014-05-04 17:53:41Z

1

you could use If condition before like that :

 $sql = "SELECT * FROM TABLE";

 fetch your query here 

 If(functionCall($row['FIELD'])==true) {
    your wished code here
    .......
  }

answered May 4, 2014 at 17:53

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1