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.
*SOLVED* multiple LIKE SQL statements
No replies to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users