ACTIVITY 4 ADASYS

CREATE DATABASE CUB_MSG;
USE CUB_MSG;

CREATE TABLE messages (
    id INT auto_increment primary KEY,
    subject varchar(255),
    body Text
);

INSERT INTO messages (subject, body) VALUES
('CSS Workshop', 'Join us for a CSS Workshop where we will delve deep into the intricacies of Cascading Style Sheets.'),
('PHP Debugging Techniques', 'Learn advanced PHP debugging techniques in our upcoming workshop.'),
('Introduction to XHTML', 'Join our seminar on the basics of XHTML for web development beginners.'),
('CSS Flexbox Layouts', 'Discover the power of CSS Flexbox layouts in our hands-on session.'),
('PHP Security Best Practices', 'Master the best practices for securing your PHP applications.'),
('XHTML for SEO', 'Learn how to optimize XHTML documents for better search engine ranking.'),
('Advanced CSS Animations', 'Take your CSS animation skills to the next level with our advanced workshop.'),
('Database Integration', 'Learn how to integrate databases seamlessly into your PHP applications.'),
('XHTML Accessibility', 'Ensure accessibility compliance with XHTML standards.'),
('Responsive Web Design with CSS', 'Design responsive websites using the latest CSS techniques.'),
('PHP Only in Body', 'This message contains PHP in the body but not in the subject.'),
('Proposal Review', 'Review of the proposal for PHP project.');


SELECT * FROM messages WHERE subject LIKE '%CSS%' AND body LIKE '%CSS%';

SELECT * FROM messages WHERE body LIKE '%PHP%' AND (subject NOT LIKE '%PHP%' OR subject IS NULL);

SELECT * FROM messages WHERE subject LIKE '%XHTML%';