Select Everything Before a Character

[Nathan]

So I could do this in MSSQL, but how is this done in MYSQL?

 

I data in field "order_items" like:

 

121x1

134x4

1001x2

163x1

 

What I want to do is select everything before the "x".

[Nathan]

Here we go, just figured this one out:

 

select replace(left(order_items,LOCATE('x',order_items)),'x','')

[Shole]

Here we go, just figured this one out:

 

select replace(left(order_items,LOCATE('x',order_items)),'x','')

You should post a tutorial explaining this whole thing what it does and what it is used for. I see you are good at coding stuff wish I had that knowlage

[haye55987]

You should post a tutorial explaining this whole thing what it does and what it is used for. I see you are good at coding stuff wish I had that knowlage

 

try:

left(order_items,instr(order_item,'x')). This should be a little more efficient. Basically, left() in MSSQL takes the characters in a string from starting position on the left to an integer. INSTR determines the integer location of a character (x). So it takes all the characters on the left from beginning to first X

 

This assumes that there is only one x as well. Do you need to trim the string or anything?

[Nathan]

Yeah I ended up using your example haye.

 

There is only 1 x in the data.