Re: help with mysql query's

[Ramalingam Chelliah]

Hi,
Could you give the complete schema?

Refer this page for pattern matching
http://dev.mysql.com/doc/mysql/en/pattern-matching.html

i)
SELECT * FROM
Employee
WHERE name LIKE '%T%' AND jobtitle='salespeople' OR jobtitle='clerk' ;

ii)
SELECT name,jobtitle FROM
Employee
WHERE JoinDate > '1991-06-30' AND jobtitle != 'salespeople' AND jobtitle != 'clerk' ;

I hope this helps

If date comparision doesn't work properly, look for Date functions in the MySQL Online document


Regards,
Ram.

We Learn the Most When we have to Invent