SELECT * FROM ardata
WHERE title REGEXP '.*2000.*'
change that into parameter, but if you want to search on multiple words as
OR, youll have to split them and do separate ORs on tile REGEXP per word, or
rewrite this one something like ".*(2000)|(leagus).*" perhaps, not sure if
grouping is suported
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]
You could try
SOUNDEX(str)
http://www.mysql.com/doc/en/String_functions.html
which might do what you are looking for
HTH
Peter
-Original Message-
From: Tom Johnson [mailto:[EMAIL PROTECTED]
Sent: 26 June 2003 14:23
To: [EMAIL PROTECTED]
Subject: Need your help in a search query
Hi
