thanks for the help, but what I really want is to
select all the values that are a substring of 'test'
as 't', 'te', 'tes' and 'test', and so I was trying
the query
select * from theTable
where ( theColumn || '%' ) like 'test';
I think my previous email as a litle bit confusing.
Sorry for that :-)
Andre
--- Jennifer Goodie <goodie@stripped>
wrote:
> select * from theTable where theColumn like 'test%';
> or
> select * from theTable where LEFT(theColumn,4) =
> 'test';
>
> depending on the table structure and data and
> indexing, etc. I have seen a
> performance difference between the two, test and see
> which works best for
> your application.
>
>
> 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/
>
>
---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list
> archive)
>
> To request this thread, e-mail
> <mysql-thread123741@stripped>
> To unsubscribe, e-mail
>
<mysql-unsubscribe-goodie=apolloi.com@stripped>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
>
__________________________________________________
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
