Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Liro0917
Starting Member
7 Posts |
 Posted - 2010-04-05 : 09:11:10
|
| I have a database that I need to get information from. However, one of the fields have been used for what should just be a product name,but it has, Product Name, Size, Strength I need each of these fields to be separate field. How can I extract the data with a SQL query with each field becoming it's own they are separated by a space. Is it possible? Any ideas? I am using MYSql to query the dataThanks! Liro |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-04-05 : 09:36:56
|
This is an MS SQL Server forum.How to split strings will be different between MS T-SQL and MySQL.So you should better look for help in a MySQL forum.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-05 : 09:52:08
|
| you may try posting it on mysql forum at www.dbforums.com------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
Liro0917
Starting Member
7 Posts |
Posted - 2010-04-05 : 10:05:44
|
| Thanks I will go there.Thanks! Liro |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-04-05 : 10:09:03
|
quote:
Originally posted by Liro0917
I have a database that I need to get information from. However, one of the fields have been used for what should just be a product name,but it has, Product Name, Size, Strength I need each of these fields to be separate field. How can I extract the data with a SQL query with each field becoming it's own they are separated by a space. Is it possible? Any ideas? I am using MYSql to query the dataThanks! Liro
Hint : Use substring and locate functionsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
New to this