At 7:55 AM -0700 2000-07-06, Phillip S. Baker wrote:
>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
>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
|• Text Search||Phillip S. Baker||6 Jul|
| • Re: Text Search||Paul DuBois||6 Jul|