Jump to content


Photo

*SOLVED* multiple LIKE SQL statements


  • Please log in to reply
No replies to this topic

#1 shocker-z

shocker-z
  • Members
  • PipPipPip
  • Advanced Member
  • 864 posts
  • LocationNottingham

Posted 06 June 2006 - 11:29 AM

*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
www: www.ukchat.ws | irc: irc.ukchat.ws chan: #blufudge




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users