RE: [PHP-WIN] Search expression => SQL WHERE parser?
| From: | Peter Illes | Date: | Wed, 30 Jan 2002 18:29:55 +0000 |
| Subject: | RE: [PHP-WIN] Search expression => SQL WHERE parser? | ||
| Groups: | php.windows | ||
| Request: | Send a blank email to php-windows+get-11723@lists.php.net to get a copy of this message | ||
Thanks, Flint.
I'm afraid MySQL does not have this feature :-(. OTOH what I'm looking for
is simpler than that.
E.g. let's turn
[apple pear -cherry]
into
[(FLD LIKE '%apple%') AND (FLD LIKE '%pear%') AND NOT (FLD LIKE
'%cherry%')]
Operators:
(space or +) => AND
# => OR
- => NOT
( ) => ( )
It is actually not too complicated, but I wanted to use some pre-created
general parser instead of rolling our own stuff.
Thanks, Peter