Compare strings ignore null characters in mysql
by Jayanthi[ Edit ] 2012-06-27 12:30:46
Compare strings ignore null characters in mysql
You have stored name is "sundar ji". In case names are same like "sundarji" and "sundar ji". Use mysql aggregate function "REPLACE"
SELECT * FROM customer WHERE REPLACE( name, ' ', '' ) = 'sundarji'
