I'm attempting to make a search engine with a MySQL
back end, and have run into a little problem.
I'm using the query:
SELECT * FROM listings WHERE MATCH (Name, Description,
Keywords) AGAINST ("searchString" IN BOOLEAN MODE)
LIMIT 0,25
And it returns:
You have an error in your SQL syntax near 'BOOLEAN
MODE) LIMIT 0,25' at line 1
I checked the version information, and it returned
'3.23.46'.
If someone can please help me, I'd be very greatful!
~Michael
=====
"True words are rarely beautiful, and beautiful words are rarely true."
~Anon
GatewayMU: http://gatewaymu.sourceforge.net
Project page: http://sourceforge.net/projects/gatewaymu
E-mail: [EMAIL PROTECTED]
__________________________________________________
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
