I have similar values in database:
U.S
EE.UU etc. these values are not static but dynamic!!!
How to tell SQL to find exact match and skip or allow points?
I don’t wanna use anything like this:
like ‘%word%’
I have similar values in database:
U.S
EE.UU etc. these values are not static but dynamic!!!
How to tell SQL to find exact match and skip or allow points?
I don’t wanna use anything like this:
like ‘%word%’
WHERE column = 'U.S'
OR column = 'EE.UU'
Thanks I think I need SELECT REPACE but not sure how to use it.
why do you need SELECT REPLACE if you want an exact match?
I am taking value from URL what loos like this: ee uu and SQL contains EE. UU.
ah, okay
WHERE REPLACE(column,'.','') = 'US'
OR REPLACE(column,'.','') = 'EEUU'
This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.