cgchris99 Posted December 31, 2003 Share Posted December 31, 2003 I have a select based on club name. It works for the first 10 records but when I select the next 10 it has a \'s in it. Select * from mytable where clubname like \'xyz sportsmen\'s club\' What is the right way to do this? The website is PHP driven Quote Link to comment Share on other sites More sharing options...
triphis Posted January 1, 2004 Share Posted January 1, 2004 it would be best not to have any apostrophies at all actually, butyou could do an IF statement, and if there is an \' in the title, replace it with % Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.