Comments on: Boasting? I guess so… 8) http://www.emresururi.com/physics/?p=57 a blog about physics, computation, computational physics and materials... Mon, 20 Jun 2016 16:19:33 +0000 hourly 1 https://wordpress.org/?v=4.9.3 By: admin http://www.emresururi.com/physics/?p=57&cpage=1#comment-22 Thu, 06 Mar 2008 09:14:17 +0000 http://www.emresururi.com/physics/?p=57#comment-22 even more fun than it looks! 8)

]]> By: Marcel http://www.emresururi.com/physics/?p=57&cpage=1#comment-21 Thu, 06 Mar 2008 09:07:53 +0000 http://www.emresururi.com/physics/?p=57#comment-21 Looks like fun!

]]> By: Hex, Bugs and More Physics | Emre S. Tasci » Blog Archive » Less is More MySQL http://www.emresururi.com/physics/?p=57&cpage=1#comment-17 Wed, 09 Jan 2008 09:26:50 +0000 http://www.emresururi.com/physics/?p=57#comment-17 […] can refer to my previous entry for slicing up the "val" column. I had already done this while constructing the […]

]]> By: admin http://www.emresururi.com/physics/?p=57&cpage=1#comment-16 Wed, 26 Dec 2007 15:40:43 +0000 http://www.emresururi.com/physics/?p=57#comment-16 #1-3
UPDATE dbl032 SET val1 = IF(LOCATE(“,”,val),TRIM(LEFT(val, LOCATE(“,”,val)-1)),val), val3 = TRIM(RIGHT(val,LENGTH(val)-LOCATE(“,”,val)));
#2-3
#UPDATE dbl032 SET val2 = IF(LOCATE(“,”,val3), TRIM(LEFT(val3,LOCATE(“,”,val3)-1)),val3), val3 = TRIM(RIGHT(val3,LENGTH(val3)-LOCATE(“,”,val3)));
#Clear All
#UPDATE dbl032 SET val1 = NULL, val3=NULL, val2=NULL

]]>