hello,
I was wondering if it is possible to search a mysql database by partial
strings, like say i have a name column with scotland, and i give this
string,
select * from table where name='co';
are there any signs like in linux you can say *co* to the anywhere in the
string...
Thanks
Erik
Christophe Vanfleteren - 25 Feb 2004 09:14 GMT
> hello,
>
[quoted text clipped - 4 lines]
> are there any signs like in linux you can say *co* to the anywhere in the
> string...
Try
select * from table where name like '%co%'

Signature
Kind regards,
Christophe Vanfleteren
uni - 25 Feb 2004 09:16 GMT
thanks,
> > hello,
> >
[quoted text clipped - 7 lines]
> Try
> select * from table where name like '%co%'