[Daea]

Добрый день!
Как можно послать запрос в БД с оператором LIKE?

Код:

mysql_format(connects,mysqlquery, sizeof(mysqlquery), "SELECT * FROM `connect` WHERE `Name` LIKE '%%e%'",tmp);
mysql_function_query(connects,mysqlquery,true,"GetPlayerMySQLID","d",playerid);

Выводит в mysql log

Код:

[13:51:02] [ERROR] mysql_format - invalid format specifier "%'"
[13:51:02] [ERROR] CMySQLQuery::Execute[GetPlayerMySQLID(d)] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''%s' at line 1

[kennydalglish]

mysql_format(connects,mysqlquery, sizeof(mysqlquery), "SELECT * FROM `connect` WHERE `Name` LIKE '%e%'",tmp);
mysql_function_query(connects,mysqlquery,true,"Get PlayerMySQLID","d",playerid);

[Daea]

Я просто сделал подобный запрос в БД Там нужно LIKE `NAME` = '%Dmitry%'

[SoNikMells]

pawn Код:

mysql_format(connects,mysqlquery,sizeof(mysqlquery),"SELECT * FROM `connect` WHERE `Name` LIKE '\%%e\%'",tmp);
mysql_tquery(connects, mysqlquery, "GetPlayerMySQLID", "i", playerid);

либо

pawn Код:

"SELECT * FROM `connect` WHERE `Name` LIKE '\%\%e\%'",tmp);

[Stepashka]

Читать внимательно документацию Format

Quote:

%% Literal '%'

pawn Код:

mysql_format(connects,mysqlquery, sizeof(mysqlquery), "SELECT * FROM `connect` WHERE `Name` LIKE '%%%e%%'",tmp);