Re: what does % mean?
| From: | John Krewson | Date: | Fri, 31 Jan 2003 19:19:42 +0000 |
| Subject: | Re: what does % mean? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-25313@lists.php.net to get a copy of this message | ||
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