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

TOP

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

About Luan Morina

A versatile educator who seamlessly integrates linguistic expertise, business acumen, and philosophical insight into every training session.