how to fetch data of employees which lastname start with 'P' or 'D' or 'SN' or 'AD'

Question

i tried this query

SELECT * FROM EMPLOYEES_MASTER 
WHERE FIRST_NAME LIKE 'P%' OR FIRST_NAME LIKE 'D%' OR FIRST_NAME LIKE 'SN%'OR 
FIRST_NAME LIKE 'AD%';

but are there any other solution for that ??

you can do the same task in many ways, like by using substring, but what purpose would it solve ? what you are doing currently looks fine to me — Sudipta Mondal, Jan 08 '19 at 06:33
That's probably how I'd do it. No need to get fancy, simple works. — Ben, Jan 08 '19 at 06:40
What database are you using (e.g. Oracle, SQL Server, MySQL, Postgres) ? "SQL" is just a language, not an actual product. — Tim Biegeleisen, Jan 08 '19 at 06:41
Well you could use the lastname column instead of `FIRST_NAME` if it is lastname you want to match :) — Joakim Danielson, Jan 08 '19 at 07:13
@primitpatel Please have a look at [this](https://stackoverflow.com/questions/1197026/is-substr-or-like-faster-in-oracle) as well — Jacob, Jan 08 '19 at 07:26

score 0 · Accepted Answer · answered Jan 08 '19 at 07:29

0

Try this:

SELECT * 
FROM EMPLOYEES_MASTER
WHERE REGEXP_lIKE(LAST_NAME,'^(P|D|SN|AD)');

answered Jan 08 '19 at 07:29

James Chang

1 Answers1