Dear list, I'm new to MySQL and all of it's trappings. Currently we're running PHP 3.x in conjunction with MySQL 3.22.22 and I need to get better results from my text searches. If anyone can help, thanks in advance. Currently I'm "searching" a field in my DB using this type of query: $searchQuery = "SELECT * FROM $table WHERE $table.$field LIKE '%$searchterms%' ORDER by creation_time DESC LIMIT $finishlimit,$searchamount"; It does a pretty good job of pulling up results, expect for in certain cases: 1. When the "$searchterms" variable exists in the $field that has an HTML tag right before or after that $searchterm: for example, a search for "Epson" brings up all the rows where $table.$field contains epson unless the field only contains "<a href="http://www.epson.com">Epson</a>" or "Epson</a>" or any variation of this. Doesn't anyone know if this is a problem with the MySQL pattern matching? If so, how can I overcome it? If not, and it's a problem with my code, how can I improve my code to catch all of these results? Thanks a bunch (can't wait for MySQL 4.0, which should fix this from what I understand. Sincerely, John --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
