Interview Question

What is LIKE operator?

LIKE performs text pattern matching with percent and underscore wildcards.

💡 Concept ✅ Quick Revision 🗃️ SQL

Answer

LIKE compares text with a pattern. • Percent matches any sequence of characters. • Underscore matches exactly one character. • Case sensitivity depends on the database collation and operator.

💡 SQL Example

SELECT name FROM customers WHERE name LIKE 'Ma%';

Result

Maya Mark

⚡ Quick Revision

LIKE performs text pattern matching with percent and underscore wildcards.