The Substring function in SQL is used to grab a portion of the stored data. This function is called differently for the different databases:<\/p>\n
* MySQL: SUBSTR(), SUBSTRING()
\n * Oracle: SUBSTR()
\n * SQL Server: SUBSTRING() <\/p>\n
Example : <\/p>\n
Let say u have 2 table from old db.<\/p>\n
Table1
\nuserid
\nname<\/p>\n
Table2
\nuserid
\npassword<\/p>\n
userid in table1 and userid in table2 is identical but userid in table 1 start with letters T and userid in table 2 is not start with T<\/p>\n
for example.<\/p>\n
Table1
\nuserid name
\n1 itik
\n2 ayam
\n3 kambing
\n4 bangau<\/p>\n
Table2
\nuserid password
\nT1 ******
\nT2 ******
\nT3 ******
\nT4 ******<\/p>\n
so we need to use sql substring function to erase the T to make it identical.<\/p>\n
The query :<\/p>\n
[quote]Select table1.userid, table1.name, table2,password from table1, table2 WHERE table1.userid = SUBSTR(table2.userid, 2)[\/quote]<\/p>\n","protected":false},"excerpt":{"rendered":"
The Substring function in SQL is used to grab a portion of the stored data. This function is called differently … More SQL Substring Function<\/span>