MYSQL Query rows in a database for a phrase and append it if it doesn't exist -

-

i have table column maps, , map names end phrase _csgo , others don't. possible search through specific column , if string doesn't have ending _csgo add it? thanks

this update query:

update table     set maps = concat(maps, '_csgo')     maps not '%_csgo';

actually, underscore special character in like, can do:

update table     set maps = concat(maps, '_csgo')     right(maps, 5) <> '_csgo';

Comments

Post a Comment

Popular posts from this blog

node.js - How to mock a third-party api calls in the backend -

-
i'm testing application mocha , supertest, test like var request = require('supertest'), app = require('./bootstrap.js'); describe('...', function() { it('...', function() { request(app) .get('/some/url') // ... }); }); the bootstrap.js real application before listen ports all works perfect have add calls third-party api , testing slow so when do, test example takes 5 seconds request(app) .get('/my/endpoint/that/makes/call/others') // ... how can make fake calls during test real when running application? you can use nock purpose.
Read more

amazon web services - Installing MobileFirst 7.0 server on AWS -

-
are there instructions installing mobilefirst server 7.0 on aws ec2(amazon web services). found article ( https://www.ibm.com/developerworks/community/blogs/worklight/entry/how_to_install_worklight_server_on_amazon_ec21?lang=en ), seems outdated latest versions. appreciate if has generic document installing mobilefirst on cloud services aws. mobilefirst platform foundation 7.0 not different worklight 6.2 etc, it's same new features, etc. you setup account ec2 vm, running linux, , mfpf supports linux. nothing different perspective. meaning, blog post you've found true mfpf 7.0.
Read more

Non Unique Username with ASP.Net Identity 2.0 -

-
i have situation username not unique. email used username , 1 email can have many different passwords in database , legitimate. how use asp.net identity 2.0 in situation. var result = await signinmanager.passwordsigninasync(model.username, model.password, model.rememberme, shouldlockout: false); above line expects 1 user in database. if multiple records returned - returns failure. expected logic doesn't work me. how override logic? alternatively, ready customize login problem - not sure things done part of passwordsigninasync. adding cookies etc. please help. i made work. had use username + password combination unique username. these different situations in industry different types of needs.
Read more