*SOLVED* multiple LIKE SQL statements

[shocker-z]

*SOLVED*
I was searching on a test word with caps in it :| always the last thing you try heh! :smiley:




Hi there i'm doin a litle search engine thingy majigerdy..

The SQL code my script generates is: SELECT * FROM threads WHERE topic = 'Windows XP Service Pack 2' AND thread LIKE '%xp%' AND thread LIKE '%bsod%'

What is up with it, as it works fine with just: SELECT * FROM threads WHERE topic = 'Windows XP Service Pack 2' AND thread LIKE '%xp%'

The first statement returns no records even altho i know both words are contained inside the field thread.

Anyone?

Regards
Liam