NovoWeb
asked on
MySql select string minus one charracter
Hi,
For example: I have a word like "GoodDay" that i want to search in the DB, but in the DB there is a word "Good_Day"...
Is there a function in MySql to check this word but tell it to ignore the"_" ?
Something like: SELECT text FROM db_name WHERE ingnore(text , '_') = 'GoodDay'
P.S. Beside using the %% or LIKE function
Hummmm.....
For example: I have a word like "GoodDay" that i want to search in the DB, but in the DB there is a word "Good_Day"...
Is there a function in MySql to check this word but tell it to ignore the"_" ?
Something like: SELECT text FROM db_name WHERE ingnore(text , '_') = 'GoodDay'
P.S. Beside using the %% or LIKE function
Hummmm.....
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Wonder what fulltext would do with that.
ASKER
I have check the Levenshtein function.. great but i will have to search all the DB in a loop to find one or mayby two, and i don't want 2 results.
I am tying to do something with REGEX but nothing so far...
I am tying to do something with REGEX but nothing so far...
Don't want two results? How can we help you then? Please show us a test data set and a desired result. Armed with that information we should be able to help you bridge the gap.
ASKER
The function was right but i have to figure the exact expression
Thanks!
Thanks!