Bit of PHP/SQL help please?

[Hamish]

Hi, I'm trying to select all rows from a database where a field on a row contains any of the characters in an array, is this possible?

for example $groups = "7 8 9"

I explode($groups, " ") to create an array

then try and get the right rows out the database with something like

$query = "SELECT * FROM quizes WHERE group LIKE '%$groups%'";

however firstly this doesn't work and secondly it only allows me to find 1 variable at a time

Any help greatly appreciated

 

[Lovemonk]

Couldn't you use Count($arrayName) to count the number of entries in your array and then set up a loop based on this? On the first iteration you would supply the WHERE clause of your query and on subsequent iterations you would supply the AND's.

 

[rpstewart]

You should be able to use an IN construct rather than the LIKE (at least that's how DB2 does it)

SELECT * FROM quizes WHERE group IN (group1, group2, group3)

 

[robmiller]

(at least that's how DB2 does it)

mySQL too—this is by far the best way

If you have to have them space separated, then:

$groups = mysql_real_escape_string(join(", ", explode(" ", $groups)));

$r = mysql_query("SELECT * FROM table WHERE group IN ($groups)");

 

[Hamish]

cheers guys, i'll try that later...