Samuel J. Sutjiono writes:
> This expression matches the word socks or shoes or nike in product category
> where productdescr ~* '(socks|shoes|nike)'
>
> Does anybody know what the expression should be if I want to do 'and'
> of those key words instead of 'or' ?
You probably want something like
productdescr ~* 'socks' AND productdescr ~* 'shoes' AND productdescr ~* 'nike'
I don't think it's possible to do this for the general case with just a
regular expression.
--
Peter Eisentraut peter_e@gmx.net