Selecting a substring

#1

SELECT * , SUBSTRING( `Reference` , (
LOCATE( "08", `Reference` ) ) AS TRACK
FROM `work`
WHERE `Reference` LIKE "%08-%"

This is giving me a syntax error. What's wrong?

#2

Derek Turner:

Quote:

SELECT * , SUBSTRING( `Reference` , (
LOCATE( "08", `Reference` ) ) AS TRACK
FROM `work`
WHERE `Reference` LIKE "%08-%"

This is giving me a syntax error. What's wrong?

The number of parentheses: 3x'(' and 2x')'

#3

On 07-02-11 14:25, Derek Turner wrote:

Quote:

SELECT * , SUBSTRING( `Reference` , (
LOCATE( "08", `Reference` ) ) AS TRACK
FROM `work`
WHERE `Reference` LIKE "%08-%"

This is giving me a syntax error. What's wrong?

you have 3 times a '('
and only 2 times a ')'

--
Luuk

#4

On Mon, 07 Feb 2011 13:34:16 +0000, Erick T. Barkhuis wrote:

Quote:

Derek Turner:

SELECT * , SUBSTRING( `Reference` , ( LOCATE( "08", `Reference` ) ) AS
TRACK FROM `work`
WHERE `Reference` LIKE "%08-%"

This is giving me a syntax error. What's wrong?

The number of parentheses: 3x'(' and 2x')'

Thanks for the quick response, I looked and looked but couldn't see it

And now I've got the SUBSTRING syntax the right way round it even does
what I want it to do!

#5

On 2/7/2011 9:14 AM, Derek Turner wrote:

Quote:

On Mon, 07 Feb 2011 13:34:16 +0000, Erick T. Barkhuis wrote:

Derek Turner:

SELECT * , SUBSTRING( `Reference` , ( LOCATE( "08", `Reference` ) ) AS
TRACK FROM `work`
WHERE `Reference` LIKE "%08-%"

This is giving me a syntax error. What's wrong?

The number of parentheses: 3x'(' and 2x')'

Thanks for the quick response, I looked and looked but couldn't see it

And now I've got the SUBSTRING syntax the right way round it even does
what I want it to do!

The open parens in front of Reference does not have a corresponding
closing parens.

Bill B

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Selecting a substring

comp.databases.mysql comp.databases.mysql

Selecting a substring - 02-07-2011 , 07:25 AM

Re: Selecting a substring - 02-07-2011 , 07:34 AM

Re: Selecting a substring - 02-07-2011 , 07:55 AM

Re: Selecting a substring - 02-07-2011 , 08:14 AM

Re: Selecting a substring - 02-07-2011 , 09:06 AM