[Kyance]

Quote:

Originally Posted by Pottus Make sure you insert a literal %% to indicate a wildcard.

Quote:

Originally Posted by FUNExtreme Wildcards indeed. SQL LIKE accepts wildcards, the one you want is '%', this tells the engine that there can be 0 or more missing letters there. %string% will give you what you need. Samp escapes the % sigh so you'll need to use %% Код: SELECT * FROM `BANNED` WHERE `NAME` LIKE '%%%s%%' OR `IP` LIKE '%s' ORDER BY `DATE` DESC LIMIT 6

Thanks, I guess I wasn't using enough %'s previously.
+rep'd everyone I could
EDIT: managed to +rep everyone