This may not help with the comma problem, but your app looks like a good candidate for FULLTEXT searching, check out http://www.mysql.com/doc/en/Fulltext_Search.html for information.
Regards, Mike Hillyer www.vbmysql.com > -----Original Message----- > From: Tom Johnson [mailto:[EMAIL PROTECTED] > Sent: Thursday, June 26, 2003 7:23 AM > To: [EMAIL PROTECTED] > Subject: Need your help in a search query > > > Hi MySQL Experts, > > I am pretty new at this and need your help in figuring out if > it is possible > to create a query to search for words in a given field. What > I am trying to > do is allow a user to enter words to search for a given title in the > database. For example, a person is looking up the title > "20,000 Leagues > Under the Sea" but is entering only "20000" as the search > criteria. When I > run the following query, I get no results. The problem is > with the comma in > 20,000. Any suggestions on how to find the title even though > the user only > entered 20000??? I am running this on the web using PHP and MySQL. > Possible someone knows of a good search script in PHP that > might help also? > > Here is the query I was trying to run: > > SELECT * FROM ardata > WHERE title LIKE '%user_input%'; > > I am using MySQL 4.0.13 and PHP 4.3.2 > > Thanks for helping! > > Tom Johnson > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?> [EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
