SQLite wildcard search
#3

%c inserts character 37 which is a percent sign, i'll try your way though just in case.

Edit - Still doesn't work so it's something else Vince even if I write the whole name it will fail with the wildcard character so it's either a SAMP limitation or % is not the wildcard character.

Edit - Solution

It would appear that tutorial was wrong, here is the correct query syntax

format(Query, sizeof(Query), "SELECT `PlayerName` FROM `BannedUsers` Where `PlayerName` LIKE '%s%%'", DB_Escape(text));
Reply


Messages In This Thread
SQLite wildcard search (SOLVED) - by Pottus - 29.05.2013, 08:09
Re: SQLite wildcard search - by Vince - 29.05.2013, 08:12
Re: SQLite wildcard search - by Pottus - 29.05.2013, 08:16

Forum Jump:


Users browsing this thread: 3 Guest(s)