I have a table with ~500k rows; varchar(255) UTF8 column filename contains a file name; I'm trying to strip out various strange characters out of the filename - thought I'd use a character class: ...

How can I efficiently search json data in a mysql database? I installed the extract_json udf from labs.mysql.com and played around with a test table with 2.750.000 entries. CREATE TABLE `testdb`....

Situation: I want to create a mysql function named XMLify, that takes in a string and an expression that will return a set XMLify(string, expr) The function should wrap each returned field of ea...