Hey y'all. So, this time I'm working on a search script in PHP and MySQL. Now, the search "keywords" are worked into an SQL query based on "Any Words", "All Words", and "Exact Phrase". What I'm trying to do, is come up with a way to search for pluralized (or unpluralized) versions of the keywords.
So, it'd be:
Code:
$regexp = 'I have no clue!';
"SELECT ... WHERE column REGEXP '$regexp'"
Has anyone seen any regular expressions for pluralizing english words? I've been reading some CS papers on the topic, but it seems as though it's going to be quite a doozie.