i am using this function to match the team name in the database table in mysql:

<cffunction name="formatTeam">
        <cfargument name="teamName" required="false" default="">
        <cfreturn trim(replace(arguments.teamName, "'", "\'", 'ALL'))>
    </cffunction>

but it is ending like this in my check

select count(*) as count
from teams
where team IN ('Mots','Leaf\\''s')

doing a check like this:

<cfset local.teamName = formatTeam(arguments.teamName)>
select count(*) as count
from teams
where team IN (<cfqueryparam cfsqltype="VARCHAR" list="true" value="#local.teamName#" />)

its is stored in database as:

leaf's

OK, so, what... you want it to be compared as...

leaf\'s

?

i just want to match it using the query and return me the count that it exists

But hang on. You're dicking around with the value and substituting

'

for

\'

for some reason. Why?

the table is throwing me an error if i do

Tables don't throw errors.

figured out, there is no need to format function

That's what I figured. Hence the questions to clarify