RE: [PHP-DB] MySQL Search

select <column> from <table> where <column> like '%<word>%'; Jason Stechschulte jpstech@nc.edu -----Original Message----- From: Ben Cairns [mailto:BenC@intasept.com] Sent: Thursday, October 19, 2000 7:58 AM To: php-db@lists.php.net Subject: [PHP-DB] MySQL Search I have a database that runs a guestbook, every entry in the book has a UID. I want the user to be able to enter a word and then PHP search the database for any thing contaning that word, then provide a link to the page that reads the entry in the database. How can I search a BLOB field, or a CHAR field and select it if it matches one word? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net