Quick question about selecting multiple values in a sql query

PHP
1

So i have this:

$query = mysql_query("SELECT * FROM textareas WHERE Section = 'forskola-allmant'") or die(mysql_error());

And i want to select one more section value, how do i do this? I tried just Seperation them with a comma like this:

Section = ‘forskola-allmant’, ‘forskola-miljo’ but this didnt work, I als tried adding AND inbetween the values, didnt work either…

What is the correct way to do this?

2

You can use the || operator to enable different values to be selected:


$query = mysql_query("SELECT * FROM textareas WHERE Section = 'forskola-allmant' || Section = 'forskola-miljo'") or die(mysql_error());