Matching record with or without apostrophe [not the usual insert problem!]

[Mark_P_W]

Hi all,

I'm wanting to search a mysql table to return a record (that has an apostrophe) even if I don't specify the apostrophe in the actual search.

At the moment if I search for something like "You'll never walk alone" it will return the exact matching record, "You'll never walk alone". However, if I search "Youll never walk alone" (without the apostrophe) it will not return the record, "You'll never walk alone" and simply comes up with no matches.

I'm using the following SQL to search the table:

SELECT * FROM songs WHERE title LIKE '$title%'

Is there any way I can do this so that the search will return the same record whether or not the apostrophe is specified?

Any help would be appreciated.

[coreyp_1]

perhaps:

SELECT * FROM songs WHERE REPLACE(title, '\'', '') LIKE '$title%'