MySQL Information and Resources |
Custom Search
|
Oracle | SQL Server | Sitemap
MySQL Information and Resources |
Custom Search
|
Oracle | SQL Server | Sitemap
SQL Cheatsheet Description
Various MySQL SQL functions for working with charactor data.Cheatsheet
| Description | Function |
| Compare strings |
strcmp(string1,string2) |
| Convert to lower case |
lower(string) |
| Convert to upper case |
upper(string) |
| Left-trim whitespace (similar right) |
ltrim(string) |
| Substring of string |
substring(string,index1,index2) |
| Encrypt password |
password(string) |
| Encode string |
encode(string,key) |
| Decode string |
decode(string,key) |
If you find this site useful and are a book buyer/reader...You can support my site by clicking on one of the Links below to Abe books By doing this, I will receive a small commision on your purchase and making your purchase will not cost you any more money than if you went directly the site yourself! Abe Books sells books at a fraction of the original cost. I have purchased many books from them originally cost $40.00 for as little as $5 to $10 dollars including shipping costs Click on applicable icon to find books at Abe Books on ... |
|||
| MySQL | MySQL & Php | ||
|
|
|
||
|
Abe Books is one of my affiliates. I only use affiliates that I also purchase products from. I love Abe books. If it is printed they likely have a copy. I have also included a generic link to Abe Books below. Once on their site, you will find that they have a nice, easy to use search engine so to find what you are looking for. |
|||
