SQL like

LIKE operator is used to search for a specified pattern in a column. Like keyword is useful when we have to search those values in which there is a specified pattern given by you.




SYNTAX :
SELECT column_name(s)
FROM table_name
WHERE column_name LIKE pattern;


Read Me


It will search such strings for 'a' no matter where it is
PatternMeaning
a%It will search strings starting from 'a'
%aIt will search strings ending with 'a'
$a$



Table Name 'customers'

id

name

age

city

bill

1Tom34Paris5300
2Jhony51London 400
3Ram64Delhi20000.7
4Simon23Portland32.65



Online Execute/Compile

Quantitative Aptitude
Reasoning
Programming
Interview