Using MySQL LIKE operator you can search based on patterns. It is used in the WHERE clause in SELECT statement.
‘%’ – allows you to match zero or more characters
‘_’ – allows you to match any single character
For searching the first character starts with ‘a’ like andy, arnold:
SELECT * FROM users WHERE name LIKE ‘a%’;
For searching the last character ends with ‘ck’ like jack, drack:
SELECT * FROM users WHERE name LIKE ‘%ck’;
For searching the middle character with ‘ac’ like jack, drack:
SELECT * FROM users WHERE name LIKE ‘%ac%’;
For searching the name whose name starts with P and ends with m like pom, pim:
SELECT * FROM users WHERE name LIKE ‘p_m’;
You can also use NOT operator to like for exception:
SELECT * FROM users WHERE name NOT LIKE ‘a%’;
Battery coating is the process of applying uniform layers of active materials—such as cathode and…
Let’s face it. Tech buzzwords get thrown around a lot—especially when it comes to how…
In today’s digital world, the boundaries between technology, finance, and innovation are rapidly disappearing. Businesses…
Backyard gatherings like BBQs, family reunions, and garden parties are an exciting way to enjoy…
Marketers are always on the lookout for more effective ways to reach their target audiences.…
Does your phone control your mind more than you control your phone? Modern life exploits…