[SOLVED] Select help.

[tqla]

Hello. This will select everything from the the Search table where the Keywords field is like cookies.

 

SELECT * FROM search WHERE Keywords LIKE '%cookies%';

 

I also want to look in a field called Data in the same table.

 

How do I select everything from the Search table where the Keywords field AND the Data field are like cookies?

 

Thanks!

[Maq]

How do I select everything from the Keywords field AND the Data field?

 

I don't understand...  You are selecting from the Keywords and Data field, this is what * does.

 

Do you mean you want to search in the Keywords and Data fields?  If so, do you want to select only what is in Keywords AND Data or, Keywords OR Data?

[rhodesa]

if you want cookies to be in BOTH:

SELECT * FROM search WHERE Keywords LIKE '%cookies%' AND Data LIKE '%cookies%'

 

if you want cookies to be in either or:

SELECT * FROM search WHERE Keywords LIKE '%cookies%' OR Data LIKE '%cookies%'

[tqla]

Thank you rhodesa. I appreciate the help.

 

Maq, I noticed that I made a mistake in my original post so I modified it just as you were replying. Thanks.

[Maq]

Thank you rhodesa. I appreciate the help.

 

Maq, I noticed that I made a mistake in my original post so I modified it just as you were replying. Thanks.

 

Ah, yes I see.