MySQL 4 Syntax Question
| From: | John Taylor-Johnston | Date: | Mon, 25 Nov 2002 20:41:20 +0000 |
| Subject: | MySQL 4 Syntax Question | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-23658@lists.php.net to get a copy of this message | ||
$SQL = "SELECT AU,ST,BT,AT,id FROM ccl.ccl_main
WHERE MATCH (AU)
AGAINST ('\"Margaret Atwood\"' IN BOOLEAN MODE)
ORDER BY id desc";
When I enclose "Margaret Atwood" in double quotes, it's like having no quotes at all.
Therefore, it searches for all occurences of Margaret and Atwood.
Any inspiration?
Thanks,
John
--
John Taylor-Johnston
-----------------------------------------------------------------------------
"If it's not open-source, it's Murphy's Law."
- Université de Sherbrooke:
http://compcanlit.ca/