MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Andre Kirchner Date:November 1 2002 2:31am
Subject:How to query a varchar column's value staring with a string?
View as plain text  
Hi there,

how can I query all the values starting with 'test'?
I tried the following query, but it didn't work

select * from theTable where ( ( theColumn || '%' )
like 'test' );

Thanks,

Andre
mySQL

__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
Thread
How to query a varchar column's value staring with a string?Andre Kirchner1 Nov
  • How to query a varchar column's value staring with a string?Jennifer Goodie1 Nov
    • Re: How to query a varchar column's value staring with a string?Andre Kirchner1 Nov
      • Re: How to query a varchar column's value staring with a string?Andre Kirchner1 Nov