one MySQL example - Printable Version

one MySQL example - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: one MySQL example (/showthread.php?tid=587629)

one MySQL example - Ivan_Ino - 01.09.2015

Hello all, i have problem, i can ez make mysql search on php, but on samp i can't, i know i must use LIKE in query but i don't know how, can anyone give me example..

Код:

new search[64] = "tes"
"SELECT * FROM db WHERE text LIKE here is my problem LIKE '%%s%'", search

Re: one MySQL example - Jefff - 01.09.2015

You need use double %

pawn Код:

"SELECT * FROM db WHERE text LIKE '%%%s%%'", search

Re: one MySQL example - Ivan_Ino - 01.09.2015

Thanks bro,

)))
rep+

-Solved-