Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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%';
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement