Finding comma separated values with a colon delimiter

Posted by iconMatrix on Stack Overflow See other posts from Stack Overflow or by iconMatrix
Published on 2012-12-15T04:18:51Z Indexed on 2012/12/15 23:04 UTC
Read the original article Hit count: 142

Filed under:
|

I am setting values in my database for tourneyID,Selected,Paid,Entered,date then separating each selection with a colon

So I have a string that may look like this

    187,S,,,09-21-2013:141,S,,,06-21-2013:144,S,,,05-24-2013 

but it also could look like this

    145,S,,,07-12-2013:142,S,,,05-24-2013:187,S,,,09-21-2013

and some times is looks like this

    87,S,,,07-11-2013:125,S,,,06-14-2013

I am trying to find this sequence: 187,S,,,09-21-2013

I have data stored like that because I paid a programmer to code it for me. Now, as I learn, I see it was not the best solution, but it is what I have till I learn more and it is working.

My problem is when using LIKE it returns both the 187 and 87 values

    $getTeams = mysql_query("SELECT * FROM teams 
    WHERE (team_tourney_vector LIKE '%$tid,S,P,,$tourney_start_date%' 
    OR team_tourney_vector LIKE '%$tid,S,,,$tourney_start_date%') 
    AND division='$division'");

I tried this using FIND_IN_SET() but it would only return the the team id for this string

187,S,,,09-21-2013:141,S,,,06-21-2013:144,S,,,05-24-2013

and does not find the team id for this string

145,S,,,07-12-2013:142,S,,,05-24-2013:187,S,,,09-21-2013

   SELECT * FROM teams WHERE FIND_IN_SET('187',team_tourney_vector) AND (team_tourney_vector LIKE '%S,,,09-21-2013%')

Any thoughts on how to achieve this?

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql