[RESOLVED] AND NOT IN?

[benracer]

hi,
how can i fix this?

SELECT * from items WHERE stock='instock' AND NOT items LIKE '%OFFER%' items ORDER BY rand() LIMIT 18

Thanks 🙂

[benracer]

SORTED!!!

SELECT * from items WHERE stock='instock' AND '%OFFER%' NOT LIKE name ORDER BY rand() LIMIT 18

[NogDog]

Glad we could help. 😉