Re: SHOW COLUMNS Syntax Using 3.23.54 Please!

2005-01-18 Thread Roger Baklund
shaun thornburgh wrote: I am trying to get all field names from my table that begin with letter X or Y, however the following statement and many variations I have tried produce an error: SHOW COLUMNS FROM TABLE LIKE "X%" OR LIKE "Y%" According to the manual, the pattern for SHOW COLUMNS is: SHOW

SHOW COLUMNS Syntax Using 3.23.54 Please!

2005-01-18 Thread shaun thornburgh
Hi, I am trying to get all field names from my table that begin with letter X or Y, however the following statement and many variations I have tried produce an error: SHOW COLUMNS FROM TABLE LIKE "X%" OR LIKE "Y%" Any help here would be much appreciated :) -- MySQL General Mailing List For list ar

SHOW COLUMNS Syntax Using 3.23.54

2005-01-17 Thread shaun thornburgh
Hi, I am trying to get all field names from my table that begin with letter X or Y, however the following statement and many variations I have tried produce an error: SHOW COLUMNS FROM TABLE LIKE "X%" OR LIKE "Y%" Any help here would be much appreciated :) -- MySQL General Mailing List For list