Re: confused over where/like/select commands
| From: | Terry Mehlman | Date: | Mon, 14 Aug 2000 15:27:08 +0000 |
| Subject: | Re: confused over where/like/select commands | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-11610@lists.php.net to get a copy of this message | ||
Cameron,
Here is an example of how the like command is used:
to find $my_string is column1 of table1
select column1
from table1
where column1 like '%$my_string%'
this will find any occurence of $my_string anywhere in column1
hope this helps
> I have tried using the WHERE and LIKE commands, but am
> unclear as to how to get these to work each time by using the text
> that each person puts into the web-form.
>