[RESOLVED] Apostrophe is MYSQL Query

[Sops21]

I'm trying to create a mysql search query. The query I have follows:

$query="SELECT *, MATCH (description) AGAINST ('pero's pizza') AS 'score' FROM store WHERE MATCH(description) AGAINST('pero's pizza' IN BOOLEAN MODE)ORDER by score DESC ";

I'm not sure how to do the " ' " in "pero's pizza" If i just leave the Apostrophe in the code i get the following error message:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's pizza') AS 'score' FROM store WHERE MATCH(description) AGAINST('pero's pizza' ' at line 1

How do I fix this?

[bradgrafelman]

Sops21 wrote:

How do I fix this?

Same way you would in PHP or HTML; escape the literal quote inside the string with a backslash.

[Sops21]

bangs head into desk

Wow that was simple... I guess I was over thinking the problem... Thanks for your help