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
MySQL
Queries, joins and keeping your data clean.
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