I am new to sql and stuck

I am using MySQL. I need to write a query using BETWEEN, Like and UNION. Can
anyone one help me give an example of what a command would look like for each?

Thanks
Mzsparkle2

--
Mzsparkle2

Re: I am new to sql and stuck

mzsparkle2 wrote:
> I am using MySQL. I need to write a query using BETWEEN, Like and UNION. Can
> anyone one help me give an example of what a command would look like for each?
>
> Thanks
> Mzsparkle2
>

I think your best bet would be the MySQL manual...

http://dev.mysql.com/doc/refman/5.0/en/pattern-matching.html
http://dev.mysql.com/doc/refman/5.0/en/union.html

Re: I am new to sql and stuck

On Sun, 29 Jan 2006 04:34:25 +0000, mzsparkle2 wrote:

> I am using MySQL. I need to write a query using BETWEEN, Like and UNION. Can
> anyone one help me give an example of what a command would look like for each?
>
> Thanks
> Mzsparkle2


it's pretty straight forward:

select * from a where x between 1 and 4;
select * from a where x like '%jj';
select * from a where x = y
union
select * from b where z = aa