I need to create a keywords search.
User submits keywords in a form, and I need to match the keywords against a database table column.
Let's say submitted keywords are:
php javascript photoshop mysql
I can do this:
SELECT description REGEX 'php|javascript|photoshop|mysql';
This will select all description columns with "one or more" of the keywords.
Now here is my question...
How do I write a regex expression to select columns will ALL the keywords?
TIA,
Richie.
