Re: [PHP-DB] what does % mean?

2003-01-31 Thread 1LT John W. Holmes
> I am trying to decipher some code written by someone else. In it there > is a query: > > $query = "select description from $prodtable where description like '%' > or type like '%' group by description"; > > I've seen it used as mathematical modulos, but not sure how it's used > here. It is a wi

Re: [PHP-DB] what does % mean?

2003-01-31 Thread John Krewson
It's a wildcard Example: I'm looking for the value "A1" in a column that has values A1-1, A1-2, A1-3 select count(*) from table where column like '%A1%' will give me a count of three Mignon Hunter wrote: Hello list, I am trying to decipher some code written by someone else. In it there is a