Re: SQL wildcards???
| From: | Doug Semig | Date: | Wed, 06 Dec 2000 03:17:46 +0000 |
| Subject: | Re: SQL wildcards??? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-5033@lists.php.net to get a copy of this message | ||
Standard SQL defines the percent sign (%) to match one or more characters
and the underscore (_) to match single characters.
Check your database implementation's documentation for extensions and/or
some way of doing Full Text Indexing.
Doug
At 10:02 PM 12/5/00 -0500, Gary wrote:
>I'm new to PHP, so I have a lot to learn. Is there a way to use any of these
>string comparisons in a SQL statement? Like (select * from database where
>field = "some string comparison") I want to find every instance of a word
>that the user supplies. Are there any wildcard characters I can use?
>
>Thanks, Gary