Re: [Zope] MySQL LIKE operator

2000-07-13 Thread Phill Hugo
> > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > Sent: Wednesday, July 12, 2000 11:03 AM > > To: [EMAIL PROTECTED] > > Subject: [Zope] MySQL LIKE operator > > > > > > Hello, > > > > I&#

RE: [Zope] MySQL LIKE operator

2000-07-12 Thread Ron Bickers
> Sent: Wednesday, July 12, 2000 11:03 AM > To: [EMAIL PROTECTED] > Subject: [Zope] MySQL LIKE operator > > > Hello, > > I'm writing a search query to a MySQL database. I want to keep > people from screwing around with my database by running searches like "; &g

[Zope] MySQL LIKE operator

2000-07-12 Thread Aaron Williamson
Hello, I'm writing a search query to a MySQL database. I want to keep people from screwing around with my database by running searches like "; delete from ... yada yada. So I should use , right? But what if I want to use LIKE? If I say: WHERE goo LIKE "%%" then effectively I am saying: