Everytime when I pass a string with character ' in MYSQL query. My code crash.
I know MYSQL query use special character ' as a delimiter. Is there any function which can scan and take out character ' in the input string or text first before I pass it in my query?
Thanks in advance.
Tom
I know MYSQL query use special character ' as a delimiter. Is there any function which can scan and take out character ' in the input string or text first before I pass it in my query?
Thanks in advance.
Tom