Results 1 to 3 of 3
Thread: queries AND OR
Jan 28, 2005, 23:48 #1
- Join Date
- Oct 2004
- United states
- 0 Post(s)
- 0 Thread(s)
queries AND OR
i have a question.
If let say i want to select fields in my database, with the condition of type=articles AND content=%keyword% OR subject=%keyword%
what i want is that i want to choose only entries which type HAS to be = articles AND content or subject, either one or both to contain %keyword%
please help me
when i do
WHERE type ='articles ' and subject like '%".keyword."%' and content like '%".keyword."%' ";
it will return entries where type = article AND subject containing keyword AND content containing keyword
which is different from what i want.
i want to return type=article AND either content or subject containing keyword
meValentine's Day Gift for your girl,
but you have to know her size
have a nice day then.