Skip to content

Instantly share code, notes, and snippets.

View mlepicki's full-sized avatar

Marcin Łępicki mlepicki

  • Białystok, Poland
View GitHub Profile

Keybase proof

I hereby claim:

  • I am mlepicki on github.
  • I am mlepicki (https://keybase.io/mlepicki) on keybase.
  • I have a public key ASBt_1PUxjzS6sjP0a4gUIeo8S_0n3wvB0rO3JY2hZl1lwo

To claim this, I am signing this object:

@mlepicki
mlepicki / gist:1807713
Created February 12, 2012 10:06
I see what you did there
db.execSQL("update products set searchString = replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(lower(name),\"ą\",\"a\"),\"ś\",\"s\"),\"ć\",\"ć\"),\"ź\",\"z\"),\"ż\",\"z\"),\"ł\",\"l\"),\"ó\",\"o\"),\"ę\",\"e\"),\"ń\",\"n\"),\"(\",\"\"),\")\",\"\"),\".\",\"\"),\",\",\"\"),\"_\",\"\"),\"&\",\"\"),\"\"\"\",\"\"),\"'\",\"\"),\"-\",\"\"),\"Ż\",\"z\"),\"Ź\",\"z\")");
db.execSQL("update brands set searchString = replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(replace(lower(name),\"ą\",\"a\"),\"ś\",\"s\"),\"ć\",\"ć\"),\"ź\",\"z\"),\"ż\",\"z\"),\"ł\",\"l\"),\"ó\",\"o\"),\"ę\",\"e\"),\"ń\",\"n\"),\"(\",\"\"),\")\",\"\"),\".\",\"\"),\",\",\"\"),\"_\",\"\"),\"&\",\"\"),\"\"\"\",\"\"),\"'\",\"\"),\"-\",\"\"),\"Ż\",\"z\"),\"Ź\",\"z\")");
db.execSQL("update tags set searchString = replace(replace(replace(r