code_junkie

Is there a MySQL command to convert a string to lowercase?

Nov 11th, 2011
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. UPDATE table SET colname=LOWER(colname);
  2.  
  3. select LOWER(keyword) from my_table
  4.  
  5. mysql> SELECT LOWER('QUADRATICALLY');
  6. -> 'quadratically'
  7.  
  8. SELECT LOWER(column_name) FROM table a;
  9.  
  10. SELECT column_name FROM table a where column = LOWER('STRING')
  11.  
  12. strtolower()
Add Comment
Please, Sign In to add comment