pleas i how can select multiple colums with the where statement.e.g
select * from tablename where name=$inputname, name=$inputname, name=$inputname,
this is the kind of sturf i want to achieve.pleas help
Sos how to selec multiple roll with more one than where Sos
Moderator: General Moderators
Re: Sos how to selec multiple roll with more one than where Sos
If you want to select rows based on values in different columns, use the AND operator:shaun112 wrote:pleas i how can select multiple colums with the where statement.e.g
select * from tablename where name=$inputname, name=$inputname, name=$inputname,
this is the kind of sturf i want to achieve.pleas help
Code: Select all
SELECT * FROM tablename WHERE city=$inputcity AND country=$inputcountry AND dateofbirth < '1991-10-04'Code: Select all
SELECT * FROM tablename WHERE name=$inputname1 OR name=$inputname2
SELECT * FROM tablename WHERE name IN($inputname1, $inputname2, $inputname3)