title: procedure which does string comparison in mysql
body: <p>My requirement is some thing like this. If I want to search a string "Bangalore" in the table. But the in the table their are some leading spaces and trailing spaces before and after the string. How to write a procedure which helps me to search the string in mysql. I want to search the string during the procedure call</p>