Logo Luan Morina
Convert values to lowercase

You can convert all values of a column to lowercase without losing data with this command:

UPDATE table_students SET column_student_code=LOWER(column_student_code);
MySQL Snippets
Change column position Convert values Replace unicode characters Escape special characters
LIST OF JQUERY SNIPPETS
   Convert values of a column to lowercase
Change column position Convert values of a column to lowercase Count the number of rows in a table Display a comma after each value, except after the last one Display records Display records in a Bootstrap Table
Display records in columns Display records with Bootstrap pagination Display records with CSS styles Escape all special characters in a string Highlight the search term in the search results Replace unicode characters by utf-8 characters
Search autocomplete with Bootstrap Typeahead Search records by an option Select table rows with the current day and month Strip HTML tags