Help with mysql where...

[feri_soft]

So how to put many parameters into the where clause.For example i have 5 cat ids and i want to select all
data that matches one of the 5 categories.CAn you give me the sql code please ;)

[Barand]

Something like

[code]SELECT ... whatever... FROM tablename WHERE catID IN (1,2,3,4,5)[/code]

[feri_soft]

And one more question.I have the cat ids in the articles table,but the categories names are in other table,so how when i am listing the articles instead of the catid to list the catego ry name.How to joint the tables or...i dont know.

[Barand]

[code]SELECT a.name, a.author, c.cat_name
FROM article a
INNER JOIN categories c ON a.cat_id = c.cat_id[/code]

[feri_soft]

I understood that category and article are my tables but what are all those a and c.If i put the code exactly as is would it work or the a and c must be changed?

[feri_soft]

bump

[Barand]

They are table aliases, defined in the query

FROM article [b]a[/b]
INNER JOIN categories [b]c[/b]

It makes the query easier to read than

[code]SELECT article.name, article.author, categories.cat_name
FROM article
INNER JOIN categories ON article.cat_id = categories.cat_id[/code]

[feri_soft]

Thank you!

[feri_soft]

hmmm,how to select c.cat_name from articles as it is not in the articles table but the categories !?