Hello, I have faced such problem:
I wish to get from a database a name of the player, not equal value, but like as.
Directly from a database it looks so: (My nick name is nepopus)
SELECT pp.name FROM ps_plr_profile as pp WHERE pp.name LIKE '%epopu%' ORDER BY pp.name ASC LIMIT 1
in .sma file I entered:
new uniqueid[32]
new fmt[1024]
format(uniqueid, 31, "epopu")
format (fmt, 1023, " SELECT pp.name FROM ps_plr_profile as pp WHERE pp.name LIKE '%%s%' ORDER BY pp.name ASC LIMIT 1 ", uniqueid)
new Handle:rquery = SQL_PrepareQuery (sqlconnect, fmt)
and in game i got a error with "LIKE='
%%s
%'", how can i do it with '%', '%', but w/o error

huh... i hope you will understand my eng
P.S. its last step for my first version ingame rank system for psychostats, and ill post it when remove this error
__________________