sql - Mysql Update Records -
I need to update a column from my user table. Current record in user table
** id, user_name ** 1, true Rathore 2, Dilip Chohan 3, summer Jain
I update user_name Like Columns like
1, Sachin Rathore 2, Dilip Chauhan 3, Garam Jain
User's column should be in the form of the title of each word The first letter should be
Here is a query that will do this
Update Set Table SET user_name = CAP_FIRST (CO NCAT (SUBSTRING_INDEX (user name, '', -1), '', SUBSTRING_INDEX (user_name, '', 1)))
it depends
Here's another one:
Comments
Post a Comment