> I want to be able to search for specific text in a field and return the > results for those rows. What is the best way to go about it? Do I use > the regex stuff or match?
You can use - ...WHERE column LIKE '%specific text%' - "use the regex stuff" (which is mostly slower than LIKE) - MATCH after you've created a full text index (which has a minimum size for the search text) It all depends on the complexity of what you search, how much data you have to search through, how fast it must be, etc. Only MATCH will use an index, but a full text index will require extra disk space... Regards, Jigal. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
