Replace and update in mysql query



 Table Name=packers

Column=contactNo

8964828952,8964828951

8964828952,8964828951

want to replace every  8964828952 to 9109595911 from contctNo column

UPDATE packers SET contactNo = REPLACE(contactNo, '8964828952', '9109595911')

Comments

Post a Comment

Popular posts from this blog

Target class controller does not exist - Laravel 8

Image
  "In previous releases of Laravel, the RouteServiceProvider contained a $namespace property. This property's value would automatically be prefixed onto controller route definitions and calls to the action helper / URL::action method. In Laravel 8.x, this property is null by default. This means that no automatic namespace prefixing will be done by Laravel." Laravel 8.x Docs - Release Notes   You would have to use the Fully Qualified Class Name for your Controllers when referring to them in your routes when not using the namespace prefixing. use App \ Http \ Controllers \ UserController ; Route::get( '/users' , [UserController::class, 'index' ]); // or Route::get( '/users' , 'App\Http\Controllers\UserController@index' );  
Read more