Find specific value in comma list in database

Question

In one of my tables, I have a column where it has a comma-separated list of users that have bought that item. IMAGE

How can I read the list and run a PHP script to find if the user that is logged in (that is stored in the Session) is in that list. For example, how could I see if the logged on user (MTNOfficial) is in the list. I think it's a PHP if statement with a MySQL CONCAT or FIELD_IN_SET or something.

I need it to be in a php if statement to say IF the user that is logged in is in the list, then, else.... — Darren Griffin, Jun 21 '13 at 17:33
Please provide your code instead of explanations of your attempts. — Seeta Somagani, Jun 21 '13 at 17:48

score 2 · Answer 1 · answered Jun 21 '13 at 17:28

2

Use FIND_IN_SET() to find the records that contain your user

select *
from your_table
where find_in_set('MTNOfficial', usersBought) > 0

answered Jun 21 '13 at 17:28

juergen d

201,996
37
293
362

How do check to see if the user exists in a php if statement – Darren Griffin Jun 23 '13 at 14:03
You can ask another question about it here on Stack Overflow. But when you do give context and detail what you want to do and where you are stuck. – juergen d Jun 24 '13 at 01:20

Esaevian · Answer 2 · 2013-06-21T17:37:12.210

Get the comma separated list, then try the php function explode() to get an array that you can loop over.

http://php.net/manual/en/function.explode.php

$target = "MTNOfficial";
$query = "select usersBought from table_name";
$result = mysql_query($query);
while ($row = mysql_fetch_array($result)) {
    $users = explode("," $row['usersBought']);
    // may want to trim() here
    for ($i = 0; $i < count($users); i++) {
        if ($users[i] == $target) {
            //we found him!
        }
    }
}

Find specific value in comma list in database

2 Answers2

Linked

Related