From: Vivek Khera Date: March 25 1999 7:23pm Subject: Re: invoque a user defined program from MYSQL List-Archive: http://lists.mysql.com/mysql/968 Message-Id: <14074.36129.186215.471311@kci.kciLink.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit >>>>> "CMC" == Claudia M Castaneda writes: CMC> We want to do string comparison using SQL. For instance: CMC> A user asks to return all the strings that have 'asmmsg' at the beginning. [ ... ] CMC> Is it possible to do this with SQL? Yes; Check out a good book on SQL from your nearby library and look up the "LIKE" operator for the "WHERE" clause. CMC> I have a routine to do this type of comparison in C; would it be possible CMC> to embed it in MYSQL? No need. v. -- =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Vivek Khera, Ph.D. Khera Communications, Inc. Internet: khera@stripped Rockville, MD +1-301-545-6996 PGP & MIME spoken here http://www.kciLink.com/home/khera/