Database Knowledge Base
Search:     Advanced search
Browse by category:
Glossary | Contact Us
Database Knowledge Base / MySQL / How to Change case to Proper in mysql

How to Change case to Proper in mysql
Print
Email to friend
Add comment
Views: 1270
Votes: 1
Comments: 34
(MySQL Version 5)
DROP FUNCTION IF EXISTS proper;
SET GLOBAL  log_bin_trust_function_creators=TRUE;
DELIMITER |
CREATE FUNCTION proper( str VARCHAR(128) )
RETURNS VARCHAR(128)
BEGIN
  DECLARE c CHAR(1);
  DECLARE s VARCHAR(128);
  DECLARE i INT DEFAULT 1;
  DECLARE bool INT DEFAULT 1;
  DECLARE punct CHAR(17) DEFAULT ' ()[]{},.-_!@;:?/';
  SET s = LCASE( str );
  WHILE i <= LENGTH( str ) DO   -- Jesse Palmer's correction from < to <= for last char
    BEGIN
      SET c = SUBSTRING( s, i, 1 );
      IF LOCATE( c, punct ) > 0 THEN
        SET bool = 1;
      ELSEIF bool=1 THEN 
        BEGIN
          IF c >= 'a' AND c <= 'z' THEN 
            BEGIN
              SET s = CONCAT(LEFT(s,i-1),UCASE(c),SUBSTRING(s,i+1));
              SET bool = 0;
            END;
          ELSEIF c >= '0' AND c <= '9' THEN
            SET bool = 0;
          END IF;
        END;
      END IF;
      SET i = i+1;
    END;
  END WHILE;
  RETURN s;
END;
|
DELIMITER ;
Showing: 1-20 of 34    »»
Comments

31 Dec, 1969   |   Guest
cosmetic database
31 Dec, 1969   |   Guest
database management system
31 Dec, 1969   |   Guest
sql current date
31 Dec, 1969   |   Guest
database
31 Dec, 1969   |   Guest
sql training course
31 Dec, 1969   |   Guest
microsoft sql server training
31 Dec, 1969   |   Guest
sql server tutorial
31 Dec, 1969   |   Guest
database programmer
31 Dec, 1969   |   Guest
online sql classes
31 Dec, 1969   |   Guest
sql contains
31 Dec, 1969   |   Guest
sql server classes
31 Dec, 1969   |   Guest
sql update syntax
31 Dec, 1969   |   Guest
sql server support
31 Dec, 1969   |   Guest
microsoft sql server 2008 r2
31 Dec, 1969   |   Guest
free database
31 Dec, 1969   |   Guest
dbms security
31 Dec, 1969   |   Guest
sql server 2008
31 Dec, 1969   |   Guest
zip code database
31 Dec, 1969   |   Guest
sql select unique
31 Dec, 1969   |   Guest
ms sql server
Showing: 1-20 of 34    »»


Add comment

Others in this Category
document If the entire data dir is backuped daily, is restoring a database just a matter of dumping the database from tape back to the data dir?
document what is Maximum size of a query in mysql?
document Can MySQL 5.0 do subqueries?
document Can MySQL 5.0 do multi-table inserts and updates?
document Does MySQL 5.0 have a Query Cache? Does it work on Server, Instance or Database?
document Does MySQL 5.0 have Sequences?
document Does MySQL 5.0 have a NOW() with fractions of seconds?
document Does MySQL 5.0 work with Dual Core Opterons?
document Is there a "MyISAM Hot-Backup" like the "InnoDB Hot-Backup"?
document Is there any improvement in error reporting when Foreign Key fails (i.e. currently does not report which column and reference failed)?
document Can MySQL 5.0 do ACID Transactions?
document What are the new Storage Engines in MySQL 5.0?
document What are the unique benefits of the ARCHIVE Storage Engine?
document Do the new features in MySQL 5.0 apply to all the Storage Engines?
document What is "Server SQL Mode"?
document How many modes are there in "Server SQL Mode"?
document How do you configure "Server SQL Mode"?
document Is the mode dependent on the Database or the Connection?
document Can "Strict Mode" rules be extended?
document Does "Strict Mode" impact performance?
document What is the default mode when MySQL 5.0 is installed?
document Where can I find documentation for MySQL Stored Procedures?
document Where is the discussion forum for MySQL Stored Procedures?
document Where can I find the ANSI SQL 2003 specification for Stored Procedures?
document How do you manage Stored Procedures?
document Is there a way to view all Stored Procedures in a database?
document Where are Stored Procedures stored?
document Is it possible to group SPs into a package (e.g. like Oracle)?
document Can a SP call another SP?
document Can a SP call a Trigger?
document Can SPs access a single Table? Multiple Tables?
document Do SPs have a "raise" statement to "raise application errors"?
document Do SPs have Exception Handling?
document Can SPs return result sets (as do MS SQL and Sybase)?
document Oracle uses mod_plsql as a gateway on Apache to talk directly to a SP in the database. What is the MySQL equivalent?
document Can I pass an array as input to a SP?
document Can I pass a cursor as an IN parameter to a SP?
document Can I return a cursor as an OUT parameter from a SP?
document Can I print out a variable value in a SP for debugging?
document Where can I find documentation for MySQL Triggers?
document Where is the discussion forum for MySQL Triggers?
document Do you have Statement-level Triggers or Row-level Triggers?
document Does MySQL 5.0 have built-in Roles Based Access Control (RBAC)?
document Does MySQL 5.0 have built-in Authentication against LDAP directories?
document Will the SSL Support be built into the MySQL Binaries or will it require a recompile?
document Does MySQL 5.0 have native support for SSL?
document Have the Table Types changed from MySQL 4.x to 5.0?
document How do you migrate from MySQL 4.x to 5.0?
document Does MySQL 5.0 include a disk-based MySQL Cluster?
document Does MySQL 5.0 work with MySQL Cluster?
document When will mysqldump actually dump the definitions of SPs, Triggers, and Functions?
document When will Backup/Restore and mysqldump work with SPs?
document How does PostgreSQL compare to other DBMSs?
document what this error does mean at 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock'
document What is Data Mapping
document What is an Ad Hoc Query?
document How to change the collation for all tables in a MySQL database to UTF8?
document How we can improve MySQL DB Performance?
document Where i can find data sets?
document any free mysql Query Analyzer?
document Which is best free Hosting for PHP, MySQL and with out ads
document Getting error "MySQL Server has gone away" in php
document MySQL Simple Basics


RSS
Powered by KBPublisher (Knowledge base software)