RE: [PHP] Searching My Database

[snip] I've read around the subject of searching and although using the FULLTEXT capability of MySQL might be the proper way of doing this I feel it's somewhat limited and have decided to use a simple select procedure. [/snip] Once again, might this not be better on the MySQL list? They may explain a way to eliminate the limitations you perceive, but I digress... Depending upon how your users will be entering the search term you could build the query dynamically using PHP. We most often do something like this where we have to retrieve a list of values from one table and then run that dynamic list against other tables.