Remove anything from table's column in mysql using query


  

If you want to remove anything from your table column values.

Suppose in yourtable have column name email and all email values have ,(comma).

Example : abc@gmail.com, 

UPDATE YourTable
SET `email` = REPLACE(`email`,',','') 
WHERE `email` like '%,%';

 

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