MySQL query with LIKE - 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: MySQL query with LIKE (/showthread.php?tid=508714)

---

MySQL query with LIKE - Leenert - 23.04.2014

Hey guys,
I've got the following problem:

My query has to look like: SELECT * FROM `xyz` WHERE `abc` LIKE '%FFF%'
The % before and behind the FFF are very important, but I don't know how to put them in the query, because pawn escapes them. When I try to print the query, there is just "SELECT * FROM `xyz` WHERE `abc` LIKE 'FFF'"

Hope someone can help me...

---

Re: MySQL query with LIKE - Konstantinos - 23.04.2014

It should be: SELECT * FROM `xyz` WHERE `abc` LIKE '%%FFF%%'

---