[Gambas-user] mysql seach string contains single quote

[bill-lancaster]

Have seen a couple of posts that refer to this but can't quite understand the
answer

I have a database which conntains a string  'Queen's Head'

so 
     hResult = hConn.Exec("SELECT contacts.* FROM contacts WHERE Title =
'Queen's Head'")
produces an error.

How best to solve this?



--
View this message in context: http://gambas.8142.n7.nabble.com/mysql-seach-string-contains-single-quote-tp42768.html
Sent from the gambas-user mailing list archive at Nabble.com.