ignore the first sting in order

Hi all, I want to order a result with ignore the first word when it begins with a _. Begin the first word with a _ use the next word. Can I do it with SQL? Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files Thanx Bernd

Re: ignore the first sting in order

Hi Aleksandar, On Mon, Apr 08, 2002 at 04:43:11PM +0200, Aleksandar Bradaric wrote: Table example: _The Rock Scary Movie X-Files With order I want the output Scary Movie _The Rock X-Files After reading your message again, look like this is what you've been searching

get difference between two tables

Hi all, I want to get the difference between 2 tables. table_1: column_1 A B C D table_2: column_2 B C What is the sql select syntax to get as result A,D or B,C? Thanx for your help. Regards, Bernd - Before

Re: get difference between two tables

Hi David, On Wed, Apr 03, 2002 at 02:10:03PM +0200, David yahoo wrote: mysql select table1.* from table1 LEFT JOIN table2 ON table1.column_1=table2.column_2 where table2.column_2 is NULL; try this to select row of table 2 not in table 1, i think. Yes, it's working.