Why wont this work?

[dominod]

Hi !

 

I am trying this code:

   $query = "SELECT * FROM `table` WHERE name LIKE '%$keyword%' AND blocked != '%no%' ORDER BY hits DESC LIMIT 10 ";

 

The 'blocked' row has the following value: "se dk no uk es"

 

Now, what I want it to do is to NOT include that row IF it finds "no" in the blocked row... The problem is that it dont block it :/ It works if I dont use wildcard characters and the 'blocked' row = 'no' but I want to have multiple values in that row...

 

 

Thanks in advance

 

[mikosiko]

maybe you can try

 

$query = "SELECT * FROM `table` WHERE name LIKE '%$keyword%' AND LOCATE(' no ', blocked) = 0 ORDER BY hits DESC LIMIT 10 "

 

if the 'no' is always in the middle of the string... wouldn't work if is in the borders.  assuming that 'no' will be no part of other part of the string just use LOCATE('no', blocked)

[dominod]

Solved it with

 

AND blocked NOT LIKE '%no%'

 

Thanks