modify table data

R

raj007

Joined
Sep 26, 2012
Messages
6
Reaction score
0
In mysql i have table called user. And it contains data like
user
xyz.abc
123.abc
atr.abc etc.....
I need a query such that output should not contain the names after dot(.)
 
if you're using SQL Program, i think you mean "MySQL" then you can use the function "CharIndex"

the statment should be something like this

"Select Substring(ColumnName,0,CharIndex('.',ColumnName)) as NewUserID From TableName"

0 is Start Index
CharIndex will Return the index number for the '.' and it will be the same the supposed length for the string without the .abc
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Rearrange sheet data 3
VBA - retrieve data on last create named range from previous inserted named range 0
Transpose 2 rows to 2 columns 1
Sum up by cust w all details 2
15 seconds delay before DNS lookup 1
Hitting the limits with large table in Excel containing 1 millionrecords. What is the best option fo 2

Back
Top