August 29, 2008 07:05pm pdt

1. angelIII 570,430
2. hielo 346,742
3. ee_rlee 214,994
4. hernst42 206,049
5. routinet 202,175
6. mankowitz 125,072
7. virmaior 117,794
8. cedlinx 108,640
9. yodercm 94,799
10. fibo 89,786
11. Ray_Pas... 84,639
12. adrpo 80,750
13. leannonn 67,530
14. logudotcom 66,927
15. nplib 62,300
16. Nellios 60,570
17. paulop1... 59,650
18. rowejd 57,089
19. teraplane 56,888
20. mattaob 55,300
21. TomasHelgi 54,810
22. Thomasian 54,160
23. arnold 53,430
24. asvforce 52,850
25. psadac 52,690

1. angelIII 1,926,269
2. todd_far... 1,720,337
3. snoyes_jw 765,508
4. Raynard7 699,112
5. hernst42 564,749
6. Squeebee 555,077
7. leannonn 446,466
8. NovaDeni... 361,834
9. hielo 351,342
10. akshah123 324,132
11. virmaior 310,060
12. psadac 307,681
13. AdrianSRU 304,702
14. routinet 300,380
15. yodercm 252,668
16. fibo 233,919
17. mankowitz 217,294
18. ee_rlee 214,994
19. ushastry 205,702
20. teraplane 184,874
21. ldbkutty 184,558
22. racek 181,131
23. steelseth12 176,495
24. VGR 168,741
25. gamebits 165,040

09.26.2007 at 04:34AM PDT, ID: 22853369

	[x] Attachment Details

(MySQL) Change first character of each row to uppercase

Asked by jtcy in MySQL, PHP and Databases

Tags: first, mysql, character, uppercase, change

I have a table storing over 100k records. I want to change the first character of each to an uppercase. Is there an easy way to do it in phpmyadmin SQL pad?Start Free Trial

Keywords: (MySQL) Change first character of e…

	Title
1	Problems importing a .sql file using ph…
2	MySQL sytax error on back-up file??
3	Replace text in mysql via phpmyadmin
4	Cannot change data using phpMyAdmin
5	mysql_connect error Can't connect t…
6	phpMyAdmin: How to Import mySQL …

Loading Advertisement...

20080716-EE-VQP-32 / EE_QW_1_20070628

(MySQL) Change first character of each row to uppercase

Asked by jtcy in MySQL, PHP and Databases

Tags: first, mysql, character, uppercase, change

About this solution