Hi,
i want to write a query for employee's who's name start with "a" and end with "b".
Thnks in advance :)
virendra_sharma
-1
Light Poster
Recommended Answers
Jump to PostSee
WHERE column LIKE
All 4 Replies
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
See WHERE column LIKE
virendra_sharma
-1
Light Poster
See
WHERE column LIKE
i want to write the query for e.g there a name RICKY now i want a query where name start
with R and end with Y , so that we will get output like RICKY
simplypixie
123
Posting Pro in Training
SELECT * FROM table_name WHERE column_name LIKE 'R%' AND colum_name LIKE '%Y'
pritaeas
2,194
¯\_(ツ)_/¯
Moderator
Featured Poster
or:
SELECT * FROM table_name WHERE column_name LIKE 'R%Y'
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.