PHP, mySQL and Apostrophes

programming
1

I am trying to setup a search function using the “LIKE %$var%” method, but I have run into a problem.

The data in the database is like so: “Person’s Item”

If I search “Person’s Item” the data is retrieved successfully.

If I search “Persons Item” without an apostrophe, the retrieval is unsuccessfully.

Is there any way to get mySQL to ignore apostrophes both on the user and database side? so either of the above examples can be entered and successful?

2

You can use escape characters in the statament so this should work:

like ‘%person’s%’