Mysql remove a special charecter which occurs after a specific special character -

-

the data in cell "0^0^@1@^0^0^1^0" , want 0^0^@1@0^0^1^0 . looking , want remove special character "^" occurs after "@". note remaining "^" should remain is.

i think want replace():

select replace(col, '@^', '@')

Comments

Post a Comment

Popular posts from this blog

Failed to execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project.Error occurred in starting fork -

-
i searched on internet provided answers did not in building project. the error starting fork. tried following methods: mvn clean install -u when searched, people said because of java 7 , should work java 6. using java 6 only. some said set surefire plugin this: <groupid>org.apache.maven.plugins</groupid> <artifactid>maven-surefire-plugin</artifactid> <version>2.5</version> <configuration> <skiptests>false</skiptests> <testfailureignore>true</testfailureignore> <forkmode>once</forkmode> </configuration> the actual error is: [error] failed execute goal org.apache.maven.plugins:maven-surefire-plugin:2.12:test (default-test) on project junitcategorizer.instrument: error occurred in starting fork, check output in log -> [help 1] org.apache.maven.lifecycle.lifecycleexecutionexception: failed execute goal org.apache.maven.plugins:maven-surefire-plugin:2...
Read more

unity3d - Fatal error- Monodevelop-Unity failed to start -

-
Image
i installed unity monodevelop seems not been installed tried open script in unity nothing come out, saying should find software opens when have set preferences monodevelop(built-in). then reinstalled again, time, contains visual studio too. can open visual studio. when tried open monodevelop, following pop-up apear. but have installed 2 things /net , gtk. shown below. problem? 1st time-- install gtk after install unity(no monodev) 2nd time-- install monodevelop unity went monodev website , says xamarin studio not monodevelop you messed in first step. you have uninstall gtk , else installed during time. includes unity too.if possible, system restore , set restore date time before installed of this. now, install unity, make sure monodevelop selected unity , install it. don't install gtk or other software. when using unity, monodevelop must installed unity , not other website. reason because using customized version of monodevelop .
Read more