On Tue, 09 Dec 2003 13:24:03 -0500, Michael Stassen <[EMAIL PROTECTED]> wrote:
> >You don't want to filter the quotes from the input string, because they >exist in the data. (Well, you could filter from both sides, but that's >inefficient.) What you need to do is escape the quotes with backslashes >before sending them to mysql. Then your query will look like this: > Michael, thanks for answering I've solved some of my quote problems (which were just down to mistakes).(BTW LIKE does NOT ignore quotes) How would you filter say non-alphanumerics from the input string? What is the syntax? I've previously wanted to do a regexp on the input string but this not seem to be permitted zzapper -- vim -c ":%s/^/WhfgTNabgureRIvzSUnpxre/|:%s/[R-T]/ /Ig|:normal ggVGg?" http://www.vim.org/tips/tip.php?tip_id=305 Best of Vim Tips -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
