PHP/MYSQL match against query

mysql match against
user1260310 picture user1260310 · May 30, 2012 · Viewed 8.4k times · Source

I am trying to run a match against query and it is not working. I created a full text index on the two fields. But am getting sql error right before word 'relationship". Here is sql:

"SELECT * FROM pages WHERE MATCH (shdescript,ldescript) AGAINST (romance, relationship)";

I have also tried just searching against shdescript and just searching against ldescript but get same error. Also I've tried searchstring without spaces. As far as I know, you are supposed to have the words of the searchstring separated by commas in parentheses. What am I doing wrong? Thanks.

Answer

Scott Saunders picture Scott Saunders · May 30, 2012

Add quotes around your search string.

Related questions

MySQL SELECT query string matching

Normally, when querying a database with SELECT, its common to want to find the records that match a given search string. For example: SELECT * FROM customers WHERE name LIKE '%Bob Smith%'; That query should give me all records …

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More
How can I prevent SQL injection in PHP?

If user input is inserted without modification into an SQL query, then the application becomes vulnerable to SQL injection, like in the following example: $unsafe_variable = $_POST['user_input']; mysql_query("INSERT INTO `table` (`column`) VALUES ('$unsafe_variable')"); That's …

Read More