Question 88573 in Mysql Question posted in
The official MySQL documentation can be found here.

how to implement mysql IN(,) function inside PHP for flutter use

I’m trying to use the mysql IN(,) function for flutter use, to retrieve two values from a single column

"SELECT * from TABLE WHERE COLUMN
IN (VAL1,VAL2) "<= Now this works fine in thunder client, I just want to implement it for flutter use, I tried:

"SELECT * from TABLE WHERE COLUMN
IN (?,?) " <= but I didn’t know how to assign it to the PHP variables.

please help

Tags:

2

Answers


  1. 0

    If you just want to concat PHP variable to a string, try this:

    "SELECT * from TABLE WHERE COLUMN IN ('".$VAL1."','".$VAL2."') ";
    Login or Signup to reply.
  2. 0

    You can:

    $yourVars = "'111', '222', ";
        
$q = "SELECT some_stuff FROM TABLE_NAME WHERE column IN (". $yourVars . ") ";
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search