Dev log
Remove or escape illegal characters in a MySQL string
There are two jobs here. Stop quotes breaking a query with prepared statements, and clean unwanted characters out of stored data with REPLACE, TRIM or REGEXP_REPLACE.
4 min read
Dev log
Remove or escape illegal characters in a MySQL string
There are two jobs here. Stop quotes breaking a query with prepared statements, and clean unwanted characters out of stored data with REPLACE, TRIM or REGEXP_REPLACE.
4 min read