[PHP-DB] Search for whole words in MySQL 3.23

Hi all, I'm setting up a database search on a site, where I will essentially be BOOLEAN searching about 6 database fields. Unfortunately, the database I'm using is MySQL version 3.23 (completely out of my control), so I cannot use IN BOOLEAN MODE to simplify the process on my end. I've been able

Re: [PHP-DB] Search for whole words in MySQL 3.23

I suck at regex, but looks like 3.23 may actually support it. And most regex implementations have a word boundary code for doing exactly what you're talking about. Referring to this page: http://dev.mysql.com/doc/refman/4.1/en/regexp.html I found this example.. hopefully it'll help you (and

Re: [PHP-DB] Search for whole words in MySQL 3.23

TG - This is exactly what I was looking for. Thanks a bunch. Zeth On 6/13/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: I suck at regex, but looks like 3.23 may actually support it. And most regex implementations have a word boundary code for doing exactly what you're talking about.