Php query for imploded value

Question

I have a table column where the value is an imploded value like this 5,9,1,6,4,8,2,24,14,3 now I want to run a query possibly like this SELECT * FROM table WHERE /* 1 is in array of (imploded_table_column)*/ Please I don't have a clue on how to run such query anyone with an idea or do I have to run the query in a long way like this:

$query = mysqli_query($con, "SELECT * FROM table");
$sql = mysqli_fetch_array($query);
$val = $sql['imploded_column'];
if(in_array('1', $val)){
    //run code here
}

Please add your problem statement in detail. Question is not clear. — Sachin I
– Sachin I, Commented May 16, 2016 at 5:38

Denis Bhojvani · Accepted Answer · 2016-05-16 05:45:36Z

4

i think you are looking for FIND_IN_SET function.

SELECT * FROM table WHERE FIND_IN_SET($yourValue, column-name)

try like below query in this FIND_IN_SET function 2 arguments first value which you want to find second your table column name.

More about FIND_IN_SET function read here

answered May 16, 2016 at 5:45

Denis Bhojvani

7941 gold badge9 silver badges18 bronze badges

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

Comments

Murad Hasan · Accepted Answer · 2016-05-16 05:46:19Z

1

You can use IN or find_in_set to solve this problem if you want this as mysql.

SELECT * FROM table WHERE 1 IN (imploded_column);
SELECT * FROM table WHERE find_in_set(1, imploded_column);

OR

You can use in_array if you want it as PHP solution. Just explode the $sql['imploded_column'] so it will be an array, after that you can use in_array.

$query = mysqli_query($con, "SELECT * FROM table");
$sql = mysqli_fetch_array($query);
$val = explode(",", $sql['imploded_column']);
if(in_array('1', $val)){
    //run code here
}

answered May 16, 2016 at 5:46

Murad Hasan

9,5932 gold badges23 silver badges43 bronze badges

Collectives™ on Stack Overflow

Php query for imploded value

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related