Re: database question
| From: | Richard Baskett | Date: | Thu, 29 Nov 2001 12:49:42 +0000 |
| Subject: | Re: database question | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-76026@lists.php.net to get a copy of this message | ||
You could try something like this:
SELECT * FROM database WHERE text LIKE '%bingo%'
Rick
> How can I search a MySQL database field that contains sentences (VARCHAR
> datatype) or entire texts (TEXT datatype) for single words?
>
> Let's say I want to search 100 articles stored in a database field as TEXT
> for the word "bingo", is there any SQL or PHP way of doing that?
>
> Mick
>
> --
> ################################
> Michael Hall
> admin@openlearningcommunity.org
> m.hall@latis.net.au
> http://openlearningcommunity.org
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net
> For additional commands, e-mail: php-general-help@lists.php.net
> To contact the list administrators, e-mail: php-list-admin@lists.php.net
>