Escape single quotes in a SQL query

Use double single quotes. Example:

select * from user where first_name = 'N''golo';