Re: [PHP-DB] what does % mean?
> 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 wildcard, like someone else said. That exact query has a poor syntax, though.. .unless there's a method behind the madness. Since it's matching a wildcard only.. which would match everything, you could use "select description from $prodtable group by description" and get the same results. ---John Holmes... -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] what does % mean?
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 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. Thx -- John Krewson Programmer - SWORPS -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] what does % mean?
Hello list, 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. Thx -- Mignon -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php