MySQL query with LIKE
#1

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...
Reply
#2

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


Forum Jump:


Users browsing this thread: 1 Guest(s)