grails GORM escape % character

Question

I am trying to query database using GORM, when I pass '%' as value, its returning all the rows in the table. how can I escape % character?

def query="from Person as t WHERE  (firstName like :firstName)"
def v ="%"
gSearchMap[ firstName]= "%"+v+"%"
def rows = domain.findAll(query.toString(),gSearchMap,limits)

elaborate your question. What you are describing now is perfectly valid behavior. `select * from person where firstname like '%%%'` gives you all rows in a table which are not null. btw, `gSearchMap[ firstName]= "%"+v+"%"` this is wrong. — injecteer, Mar 30 '14 at 00:47
I want to select only fistname column contains % character. I get the % value from user, what is the best way to escape this character? — sfgroups, Mar 30 '14 at 01:46

score 0 · Accepted Answer · edited May 23 '17 at 12:05

0

You should check the documentation of your sql server for that syntax details.

in MySQL you would use the \ for that:

def query="from Person as t WHERE firstName like '%\\%%"

see Escaping MySQL wild cards

edited May 23 '17 at 12:05

Community

1
1

answered Mar 30 '14 at 14:26

injecteer

20,038
4
45
89

thanks, Is the function mysql_real_escape_string like this in grails – sfgroups Mar 30 '14 at 14:47

grails GORM escape % character

1 Answers1