Re: Text Search

[Paul DuBois]

At 7:55 AM -0700 2000-07-06, Phillip S. Baker wrote:
>Greetings Gents,
>
>Okay I want to search a text field in the database from some 
>specific characters, how would I go about doing that.
>
>The field is a text field that can have a large block of text copy in it.
>
>I want to search through all the records in the database based on 
>this text field and pull up all records that have the word 'game' in 
>them.
>
>How would the where statement look? I am having trouble figuring this one out.


SELECT * FROM tbl_name WHERE col_name LIKE "%game%"

More information: check the MySQL for information on the LIKE operator.

-- 
Paul DuBois, paul@stripped